DSXchange

Hi, We are currently generating 150 surrogate key state files to be used in our jobs. Our current design is Job1: get the filename and surrogate key value from the database and put all the data into a sequential file. Job2:(sequence) -> Will read each record from that file and pass the filename and ...

I had the same issue and here is how I solved it 1st way: In transformer stage use the type conversion UStringToString on your column. It will remove the appended NULL values 2nd way is to do it using a Modify stage. In the specification use the below syntax: new_column_name :string = string_trim[NU...

When I looked at the previous run after resetting, it said fault type 11. I searched through the forum and found a lot of similar errors. I finally figured that jobs were aborting because the connection to Sybase was not properly setup. I asked our admin to fix it after which the jobs started runnin...

Hi, I'm getting the following error when I run the job in Quality. Abnormal termination of stage Jobname..<transfomer stagename> detected Even when I reset the job I'm getting the same error. This problem was not there in development and it surfaced only when we moved the code to quality. Thanks, Ab...

Hi, I have the same issue. The error comes up on the unix box as soon as the job finishes on the Director. I searched through the forum and see that its something related to the timeout issue. But i dont know to increase the Timeout time. Can someone please let me know who to avoid this error. Thank...

Thanks Craig.

Hi,

Is there a function in DataStage which will return only numbers when an alpha-numeric string is passed as input to the function?
If not is there any other way to achieve this without using a routine.

Ex:
If input (919)-9727, the output should to be 9199727

Thanks,
Abhinav

Care to share? :roll: ... Sorry, I was away for a while. We read Mq messages from a custom stage, so we added extra parameters to the stage to call a C function. This C function will check if the incoming record is a trailer or not. If it is, it will hold the trailer till all the messages in the qu...

I understand Shane. Anyways thanks for your help.
We came up with a work around for the problem.

Thanks Sainath, forcefully creating a delay should work, for that I just added a Sleep 10 secs in the function.

I was just wondering if there was any way to handle it in Datastage.

I'm calling the function in a Lookup so ya the calculation will happen on the database

Not fully sure what you need. Did you try running that stage(s) / job in a sequential mode or in 1 node config ? ... Yes Sainath, the job is running on a single node. And my problem is even before my detail record is insert into the database my trailer record is calling a function which will update...

Thanks for the suggestion Shane, but we are using a custom stage called UOW.

So i will not be able to have reject links on it.

I can't use two different jobs because I need to pass some values coming in from the trailer to the function.

Hi, I have a job which reads data from a file. The file has data in the following format Header Detail Detail Detail Detail Trailer The job design is simple. I have a sequential file stage followed by a transformer which separates the header, detail and trailer. The header link will go and insert in...

I got it. Its available in the RDBMS stage. I was searching for the option in Oracle stage!

chulett wrote:You might want to look into the 'sql file' option instead of passing in the query as a parameter. ...

Can you please elaborate. I have no idea where to find the sql file option?