DSXchange

Hi,
I am trying to to pull out the list of datastage jobs and its description to a report.
Is there any easy way of doing it..

All I want is


Job Name ,Description
JOB1,Job to perform Delta operation..

Thanks Ray and DSguru2B. I took the path of recompiling the jobs which worked for me.Thanks once again.

Good Evening All, There is Datastage sequence job built as part of once off history load,which would run iteratively using the loops in datastage. We have passed the looping counter as a parameter for job instances. So for each job run, there is an instance job entry created in data stage director. ...

The parallel Sequential File stage is notoriously bad at handling quoted strings containing field delimiters. Create a server Shared Container containing a server Sequential File stage and use this ... Thanks Ray.. I have used a sever container stage with a server sequential stage in it and it work...

kandyshandy wrote:Double quote your 3rd column in your input file and read it. See if that works!

But kandy..its already double quoted in the input file..iam I getting it wrong...

Yes Eric. Thank you

A very good day to you all.. I have a sequential file as an input stage which reads a comma delimited file. I am facing problem while exporting a field in that file. I have a record layout in the below mentioned way. AAAAAAAAAAAA,BBBBBBBBBBBB,"G , G 'E L', S 'E AL",DDDDDDDDDDDDDDD,EEEEEEEE...

Yes, you can declare multiple record types in a CFF stage. I am not at a DataStage client now, but you can declare various 01-level type records in the "Record" tab of the CFF stage. Hi Andrw, Thanks for the information.I was unable to add multiple records in a single cff stage. Kindly le...

Hi, We have a mainframe file which has multiple record types(Header,Detail,Trailer) in it. Each record type has its own format. When I import the copybook structure of this file,the metadata is getting exported into 3 different record layouts. Is there any way we can read the whole file using a sing...

Can you share with us how they had you "change the configuration file"? I was under the impression that they were generally not editable. :? Yes ,in our case the changes have been made to configuration file. But modifying a dataset descriptor file can also be done. It can be edited in the...

Thanks For the replies folks.. As we are runningon an SMP configuration...the dataset files created by node2 are available in the shared memory.. IBM help desk provided solution to the problem. they have suggested to change the configuration file so that the node2 in the configuration file points to...

Unfortunately I do not believe that you can restore the partition to one of the other nodes and have it work. The location of the partitions are contained within the .ds header. You can certainly use a different configuration in your job then what was used to create the dataset, but I believe that ...

Hi, A dataset was created yesterday on a 3 node configuration. Currently one among the 3 nodes is down. We are currently running a job on 2 node configuration which uses this dataset.Thejob is failing with an error quoting that one among the three partitions is not available. We have the dataset par...

ArndW wrote:Purged log contents are deleted and are not retrievable. If you have an OS-level backup of the system one could restore the appropriate RT_LOGnnn directory to overwrite the current log file. ...

Thanks ArndW...I have checked the same.We found the logs.

Hi, The Auto-purge option for our project is initialised to 6 days. I can see the logs for the last six days for the job. We are in the middle of some analysis,wherein we need the logs for some 15 days old job run.Is there a way,we can retrive the logs which are more than 6 days old. Please help us ...