DSXchange

No problem, Craig. Just solved the problem, I shouldn't have used a lifefeed at all to read the file, I can read the EBCDIC file now.
This post can be closed.

I'm reading a EBCDIC coded COBOL file that has a binary field S9(9) comp, using the CFF stage. As as record delimiter the UNIX LF is used. Everything works fine until a record is encountered where the binary field contains a hex 0A value which is interpreted a a LF. How can I circumvent this error? ...

Ray, thats what I meant. Thanks for your answer (sorry for my late reply). At least now I know there's nothing obvious, so have to look for another solution. Thanks again. Paul.

Thanks Ray and vmcburney for your reply; it's not exact what I meant. I want to retrieve the information you mention within a job, not from the Designer or Director GUI, to do some cleanup work. Any clue?

Is there a possibility to get data lineage information in a parallel job? I want to know which tables have been touched by a list of jobs of which one has crashed for some reason, and using this information to do some cleanup activity. Thanks for any clue. Paul M.

Thanks all of you who responded to my question. I got it working now. Case closed!

I tried upper and lower case variants, but still 'ds_jobobjects' seems to be non-existent. And the docs are not very helpful on this subject...:-(

Thanks again, Hamzaqk, my ignorance! But executing it from DSSH issued the error: DataStage/SQL: Table "ds_jobobjects" does not exist. Wrong VOC configuration of DSSH maybe?

Hamzaqk,
thanks a lot for your reply. Unfortunately my XMETA repository of Datastage v8.x I use does not know these tables. I tried to figure out which of the existing tables to use instead, but got lost. Any help would be much appreciated. Gr. Paul

Hi all,
in our project we want to know which (source) version of a parallel or sequence job has carried out some data transformation. I can't find this information in the standard logging (via Director), is it available somewhere? Thanks in advance for any answer.
Paul Mulder

Dear members of this forum,
in our project we want to store information about module and version of the parallel jobs that has processed information from source file to datawarehouse. How do I do this, preferably using some user defined function.
Thanks in advance for any answer.
Paul Mulder

For a client that has Siebel with Oracle 10g installed wih UTF-8 support, we have to extract data from Siebel into flat XML files. The proces abort after a while, we found out this is probably due to varchar string export that is UTF-8 encoded. The Datastage server software was installed with UTF-8 ...

Craig, thanks again for your fast reply. If you could find the 2003 document, I would be very grateful if you could send this to me: paul.mulder@nl.ibm.com TheBird, thank you for your reply too, I know how to handle this part now, but then how do you generate this kind of input, like I mentioned in ...

Craig, thanks for your answer. Yes, I've read the XML pack designer guide. It seems the input must be delivered in denormalized format, i.e. columns with repeated content for XML elements at a higher level, and columns with detailed content at a lower level. But how must this input be created, then?...

I'm trying to write complex XML output using the XML output stage. The information comes from different tables (customer, address, contacts = phone numbers). Since addresses and telephone numbers can be mutiple for 1 customer, they must appear in repeating groups in the XML. My question: how do I pr...