DSXchange

All, I have searched for an answer and couldn't get any near by solutions to try. If possible, I want to know how to retrieve the last job log of a sequence job. I had ran the sequence job, it ran successfully, and then I have changed the name of that sequence job and also the routine name used in i...

Thank you, snegi. I have partiotined Based on a and sorted on both a (asc) and on b (desc) in the input partitioning tab in transformer. svcnt -> if i/p.a = svcolA then svcntOld+1 else 1 svcolA -> i/p.a svcntOld -> svcnt This helped me to generate sequence numbers in the order of values in col b, gr...

Ray, I did understood what you said. Can you please explain it clrealy.

Thanks

Ray, I am trying to get first and second highest records for each group, where a is key column and highest is decided based on column b. Ans to your second question, I am trying to get the both the records as 1 records, that is why I am performing a join in the end. Now I realized that my output wil...

I have a sequential file with the below data. column names: a,b,c,d,e,f 101,5,A,20,30,X 101,4,S,10,26,Z 101,1,C,15,24,R 101,3,B,20,44,S 102,7,W,20,20,D 102,2,F,40,53,T 102,1,Z,75,34,A 102,3,V,10,34,S 103,4,V,20,31,X 103,11,W,90,22,D 103,2,C,35,32,D 103,9,S,30,45,S I am trying to get highest and seco...

Chulett, Thank you for searching that for me. But I have seen those step and verified all those. I have also mentioned those details in my first post, that DB is on same server and I have verified APT_DBNAME and also provided the database name while running the job. Is there any other checks I need ...

How was the DB2 Sequence created? From what I recall, the stage has to create it which means a separate one-time job to do that. From what I recall. :wink: Chulett, At the database level it is an auto incremented value by 1. Generally if I am writing a sequel to insert values into Databse I am usin...

Have you filled in the state file (or sequence) information on the Surrogate Key tab? Ray, Yes I did. I have selected DBSequence for Source Type, I have given the table Sequence name in Source Name, Database Type - DB2, Provded Username, Password and Database Name. The database is on the same serve...

Hello All, I am getting the following error when I am trying to generate Surrogate Key in the transformer. I am using function NextSurrogateKey(). xfmr_data,0: Operator terminated abnormally: received signal SIGSEGV main_program: Step execution finished with status = FAILED. I am using DB sequence. ...

I have tried to search for it but could not find any posts on how to integrate IBM Reference Data Manager with DataStage!.

We have all the reference data sitting on IBM Ref DM hub and need to look up those code table in DataStage Jobs.

Any help is really appreciated.

Thanks

Thank you Andy and Craig.

I know loop activity has numeric and list loops. Is there a way to define a time based loop? I want to run my job until it produces a specific value. For example, I want to check row count in a table and if it is 0 I want to rerun the job after 5 minutes. Or I want to query a DB catalog to see if ce...

Thank you for encouraging me, Craig.

Thank you Craig. I am stupid and was thinking it single quotes and checking for empty.......

thanks for the explaining this to me.

Anu

Craig, As per Ray's response.... If Index(Sequence, ",", 1) = 0 Then Field(Codes, ",", Sequence, 1) Else Field(Codes, ",", Field(Sequence, ",", 1, 1)) : "~" : Field(Codes, ",", Field(Sequence, ",", 2, 1)) But as per the manual, In...