DSXchange

HI Datastage folks, I want to export the datastage job in dsx format from command line. in earlier version dsexport or dscmdexport were there. But in 8.5 I can see here that we can export the datastage job in isx format only from cmd line. Please help me to understand how can I export the job in dsx...

Thanks CHullet. It seems like that. OK. I am closing this post.

Hi Roy/Chullet/All, I have written a script to copy the dataset data into flat file by using orchadmin. But When I run the script in SIT I am getting an error like "Unable to create the temporary config file /XYZ/temp/apt2734623" , falling back to the system. and one more information I am ...

HI, I am also facing the same issue as here. Please help me on resolution of below error. Dynamic_RDBMS_35,0: Fatal Error: Fatal: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00210: expected '=' instead of 'x' Error at line 1 ORA-06512: at "SYS.XMLTYPE", li...

Hi, (1). If I use TD Enterprise Stage with Append mode, does Teradata creates internally a Fastload script? (2). How and where to get the script created by TD Enterprise stage? Thank You, ] Yes it will use the utility Fastload But you can't get it script wise. In Multiload stage you can get mload s...

There is nothing built into DataStage that does this. There are a number of freeware/public domain entries to be found for "convert integer to words c++" on Google, and the documentation shows how to create buildops and call them from DataStage. Thanks Andrw........Can we achieve this thr...

Hi ,
I am getting the data in a single column

1000
1122
1200

Output sholud be like this

1000, One thousand
1122,One thousand and one hundred twenty two
1200,Onethousand two hundred

Can you people help me on this
Thanks in Advance

Regards,
Barath

Hi, I am using FullOuterJoin in my job. All its inputs from start of the stream (this is the first job in the stream) have been kept as nullable (Yes). When I try to join based on Key fields say KeyField_1, KeyField_2. I am getting default values instead of nulls when no match is found. I managed t...

Hi, We are running multiple jobs (5-6 jobs) at a time from the scheuduler. Jobs are failing and getting the below error: Unable to start ORCHESTRATE process on node node1 (nsyrp41b): APT_PMPlayer::APT_PMPlayer: fork() failed, Not enough space. If i run the individual job then works fine. If there i...

Hi, I want to reject the data using join stage..... I want to reject the data which is not having the match ....can you please guide me how to do that ?? By using join stage you can't reject the which is unmatching to your join condition. In that case after join stage you should use filter or trans...

But ray.wurlod I am getting same error in when I am Insert into target table. I am getting below issue [IIS-CONN-TERA-005011] Field xxxx is unreferenced in the SQL statements (CC_TeraDBRecordDataSetConsumer::setDataSetDef, file CC_TeraDBRecordDataSetConsumer.cpp, line 655). Can u help with this. How...

If your source data is less means thousands you can go for Hash. If the the source data is huge means more than thousands you should go for method sort only ...other wise it throughs warnings.

Cheers.........

Hi,
First u need to create PL/I definition for that file .

sequential file -----> format----->record level---->format as ----->select mainframe(COBOL)
try with this and let me know

Hi,
I think so , when you r using reject link to oracle stage the sql code column automatically will genarate. so that you need drop that sql code column by using modify stage. then it works fine.

I think so it will help you .
Let me know once you try this.
Cheers..................!!!!

Hi,
can you use file pattern as read method....here you can give the filname with the whole path also.