DSXchange

I guess this has been discussed before.

Is the error in the sequential file read stage of the multiinstance job? What platform are you running on and have you compared your kernel settings on the development and production machines? NFILES or the like might be triggering the error. Yes, the error is in the sequential file read stage. Sun...

Hello everyone, I have an issue with the following error, reported in Datastage: ds_seqgetnext: error in 'read()' - Interrupted system call Here is the context: - there are 16 input files to be processed, with identical layout. - logic is simple, the Datastage jobs is suppose to extrat header/traile...

Not all that rare, I've seen it before. :wink: Want to share some details as to exactly what you are doing - file type, anything funky? Are you using the Filter option of the stage? Hi Craig, I am getting the same error and my jobs are using filter command (grep). Is this something known that I sho...

It will create the DSBackup directory automatically, so it's not like you have to pre-create it or anything. Make sure that you have the permissions that you would need to create/write to that directory and to overwrite any current backup copy that might already be there. Thanks craig, permissions ...

Hello, I am using Datastage 7.1 (Unix) and one of the jobs fails with this error: DSD.UVOpen mkdbfile: cannot create file /data/dstage/hash/DSBackup Did anyone experienced this? The job is using the same hash file as both lookup/reference and output, the flag for 'Backup existent file' is set on the...

I have 6 job activities (which runs simultaneously)attached to a sequencer with mode as "ANY" ,this sequencer is then connected to a send mail routine activity.In case when any one of the activity fails the sequencer works fine and the failure mail is send,but if another activity fails aft...

Hi, # and $ are special characters.Check out the help manual section on handling special characters Regards Wah Thanks... I found the Help page about the # sign in the column name. I have enabled the environment variable DS_ENABLE_RESERVED_CHAR_CONVERT to True. It still gives me the error when I ty...

I have a target AS400 file/table with a pound sign in the column name. Example, P1STR# and P1REG#. When typing the column name in the target DB stages, I get an error that DS cannot accept the # sign in the column name. How can I write data into a column with the pound # sign, when DS does not allow...

I have been creating XML files in Server jobs using Hash Files to create XML Chunks by giving the 'Data Element' as XML . I need to recreate the same thing in Parallel jobs, but am unable to find the XML DataElements in the DatSets or other stages. How does one create XML Chunks of data to be looked...

I have a command that I can run through iSeries on the command line that in turn executes a compiled command object (like a program) on the DB2 AS400. Text I type in iSeries is: "Call MYLIBNAME/MYProgName". I need to execute this command from DS8. I am trying to figure out a way to do this...

You remember correctly, but there is a caveat that none of the "go forward" plans is guaranteed to happen. Yes, it's on plan for version 8.1. Thanks all for your suggestions. I did not have the liberty to use a temporary table, but was able to use the Stage Variables to control the data u...

Check out the below link http://www.dsxchange.com/viewtopic.php?t=99149&postdays=0&postorder=asc&highlight=vertical+pivot&start=0 Hoping DS 8 works similar to DS 7.x I looked thru the link you gave... nothing in there really explains how to do it in parallel jobs. I have done it in ...

I have used a Pivot Stage in DS8 Parallel job. After performing some calculations I need to reverse pivot the data back into one row. Is there an easy way to do it? Example: Pivot output: ID1 Val1 ID1 Val2 ID1 Val3 ID2 Val1 ID2 Val2 ID3 Val3 Expected Reverse Pivot output: ID1 Val1 Val2 Val3 ID2 Val1...