Search found 37 matches
- Sat May 18, 2013 8:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Packed Decimals in Complex Flat File stage
- Replies: 18
- Views: 16437
- Sat May 18, 2013 8:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Junk Characters in datastage
- Replies: 8
- Views: 13523
Re: Junk Characters in datastage
I faced similar issue and using Translate in the db2 extarct sql helped. If you query the DB2 with hex(clm_name) it will actauuly show you the hex that needs to be translated.
Let me know if you need exact syntax for these. They can be easily found on net.
- nsg
Let me know if you need exact syntax for these. They can be easily found on net.
- nsg
- Thu Mar 21, 2013 8:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generate seq number in transformer only when the key changes
- Replies: 14
- Views: 12302
I have tried many versions of partnum, numpart, counter etc but have not been able to generate a rule that will handle first row and all teh subsequent rows for all the partitions. Just try the two examples I have provided in my earlier email considerign there are 2partitions - num - 0 and num - 1 a...
- Thu Mar 21, 2013 1:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generate seq number in transformer only when the key changes
- Replies: 14
- Views: 12302
Thanks everyone for the response. I am currently coding with sort using the key fields and hash partitioned. Keychange column is also generated. The transformer is set to same partition as well. The logic for genrating a sequence number only when the key value changes is coded with a If then else st...
- Wed Mar 20, 2013 2:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generate seq number in transformer only when the key changes
- Replies: 14
- Views: 12302
Thanks for the response. What you are saying will work if teh job is run on single node. But with multiple partitions, it is not working correcttly - Here are some tests that I had done - svkeyNew=If Keychange=1 Then (OldKey+PartNum+NumPart) Else svOldKey svGeneratedKey = svKeyNew svOldKey = svKeyNe...
- Wed Mar 20, 2013 12:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generate seq number in transformer only when the key changes
- Replies: 14
- Views: 12302
Generate seq number in transformer only when the key changes
Hello everyone, Please help me achieve in datastage a looping logic to increment a counter when the values in the loop changes. This can be very easily done in PL Sql or cobol but I need to do in datastage and donot know if datastage has good looping capabilities. Here is an exaple of my input - key...
- Tue Jul 24, 2012 11:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: generate distinct combinations for a given set of data
- Replies: 2
- Views: 2341
The bridge table has to have all the possible unique combination. The length for the bridge_key is number(10) for possible unique combinations for 28 values in the code table. eg - if the code table has 3 values (1,2,3) then the code should generate 7 distinct combinations in the bridge table - The ...
- Tue Jul 24, 2012 9:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: generate distinct combinations for a given set of data
- Replies: 2
- Views: 2341
generate distinct combinations for a given set of data
Hello, I need to create a bridge table with all possible combinations for a clms and want to know if it can be done through DS 8.7 version - Eg - Dimension table ------------------ Code_clm 1 2 3 Bridge table -------------- bridge_key.....Code_clm 0001 .......... 1 0002 .......... 2 0003 .......... ...
- Thu Apr 12, 2012 3:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: nulltovalue
- Replies: 5
- Views: 3456
Re: nulltovalue
Is "COUNTRY_CODE" a result from a lookup in earlier stages ?
- Thu Apr 12, 2012 3:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: "will partition" warning
- Replies: 2
- Views: 2655
- Wed Apr 11, 2012 2:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: "will partition" warning
- Replies: 2
- Views: 2655
"will partition" warning
Hi all, Is there a way to handle this warning - "Operator of type "APT_LUTCreateOp": will partition despite the preserve-partitioning flag on the data set on input port 0." This comes when there is a stage that has 2 outputs and 1 of it has sort / partition need. Why should it di...
- Wed Apr 11, 2012 2:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rangelkup failure message "Updatable lookup requires so
- Replies: 5
- Views: 4502
- Fri Apr 06, 2012 11:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Is the output of the aggregator stage sorted ?
- Replies: 5
- Views: 3420
ps. I added the tags around your ASCII art so it's closer to what you intended but I'm not about to spend my time cleaning it up so everything lines up perfectly. You're welcome to do that, however. Edit the post and make liberal use of the 'Preview' option.[/quote] I have modified the formating .....
- Fri Apr 06, 2012 11:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rangelkup failure message "Updatable lookup requires so
- Replies: 5
- Views: 4502
Yes, you are correct. I had APT_NO_PART_INSERTION and APT_NO_SORT_INSERTION in master sequencer and setting them to false, makes the job run just fine. Thanks for the help. The thing I did not know was that these Env_Variables get passed to all the jobs even when not specifically passed. Is it a goo...
- Fri Apr 06, 2012 9:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rangelkup failure message "Updatable lookup requires so
- Replies: 5
- Views: 4502
Rangelkup failure message "Updatable lookup requires so
Hi all, I have a sequence where there are 2 jobs - 1) Extract 2) Range lookup and craete output file. The sequence when triggered, runs both the jobs successfully and creates the file. However when the sequence is called from other sequence, the Range lookup job fails with the error message of "...