DSXchange

Hello all, One of my datastage parallel job is running for long.And, it varies from day to day with the same number of input records. On a given day it runs for about 1 hr and on some other day it runs for four hours. I have enabled APT_PM_PLAYER_TIMING variable in Admin to see the elapsed times of ...

Thanks Ray for the information. I will implement this logic in my job and check the result.

Thanks.

Use Before job subroutine to call a unix script where you can delete the first 5 lines.

Did you check if your temp space is full

Thank you so much for the reply..Figured it out

Hello, I am trying to log the details of logs of every run to a file I am using lognewest to record the newest eventid before job run and also after job run. Now, I want to use -logsum option which doesn't have the "entry" as an argument like -logdetail have. (I am using -logsum option bec...

Do a Hash partition and sort on input links before sending the data to Change Capture stage

Thank a lot for the reply....

Hello,

Can you please let me know if Webservices Transformer stage can be used in a Parallel job(if not, can it be used in parallel job with single node).
In the documentation, it was given ,
we can access web service operations within a DataStage server job.

Thanks.

I guess you can concatenate Left(CurrentDate(),'2') to YY before you convert it to YYYY

Thanks Franklin and Aruna for your response. I will try with all the possibilities and come back with the results.

Thank You!

Thanks a lot Franklin for taking time to provide me with a very helpful information. Yes, I am able to see the Record Type as Implicit in the layout if I set the record type as Fixed/fixed block under Properties. Can you please help me in understanding by sharing your thoughts on below. If my record...

Hi Aruna, Yes, I have created separate jobs (For header and Detail records) to extract just Header alone and Detail alone with single record definition in CFF stage. Those single record definition jobs ran fine but the problem comes when I tried to create Multiple Record types in CFF stage to extrac...

Hi Franklin, Can you please confirm my understanding below regarding the Data Control blockData? Data Control block is a 2 or 4 bytes filed which will show the length of the record in a Variable block file. So, to read a variable block file we need to have this Data Control Block in our input file? ...

Thanks for your response Franklin. I have tried with "Fixed" record type but unfortunately it also didn't work. The job was getting aborted with the same errors as the Fixed block job. I am waiting on receiving the Data Control Block information from the MainFrame team, I will post here as...