DSXchange

Is it a signed field - if so, you mat have to specify that.

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

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...

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...

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...

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...

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 ...

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 .......... ...

Is "COUNTRY_CODE" a result from a lookup in earlier stages ?

Thanks, Ray.

as always you have a very clear and precise answer.

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...

Thanks you all for the explaination and helping resolve the issue.

- nsg

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 .....

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...

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 "...