DSXchange

We are having an EBCDIC file which is being created by mainframe system. We wuld like to know the following things on that. 1) Generally the amount fields would be packed as "123456}". It is just an exaple. But when there is a " " in the EBCDIC file, what does it mean? IS the inp...

We have encountered issues with Parameter Sets at V8 to which we received a client-side patch; but we never saw the "uncompiled" state problem. Hi ArndW, Thanks for the response.We are actually using a list of parameters and not a parameter set. Can you please elaborate the issue faced.Pl...

Hi,

We are facing a peculiar problem with sequencers. The issue is that for some job activities the parameters go missing even after a successful run of the sequencer. The sequencer goes into Uncompiled state. Is this a bug in 8.0.



Thanks,
Prasanna

Hi there,


How do you decide how many node config file to be used in particular DataStage Job? What are factors you need to consider?

Thanks for reply,

Is there any other advantges than what you said?

Thanks for reply..

Is this feature available in DataStage 7.5.2 px?

Hi There,

I have 605 jobs in my project. I need to compile the complete 605 jobs with single action instead of just opening single job everytime in designer and compile it. Please suggest if anyone have any idea on this please.

Hi There,

Is there any advantage having parameterset over defining user defined varibales in datastage admin? Please someone can help me on this?

Hi there, Could please tell me what is best way to maintain user defined variables in DataStage 8.0. Is it better to create parameter sets or defining user defined variables in datastage admin? if so, what are the pros & cons. And also one more question, I have 300 jobs in my project, i have cal...

I am sorry. I did not post my question properly. We are using sequencers and we have so as many as 40 sequencer for 400 datastage jobs. Right now we are invoking these sequencers with required paramenters from UNIX scripts. We have scheduled UNIX scripts using cron tab in UNIX. As I understand from ...

we are using UNIX programs to invoke datastage jobs. There are 300 jobs that load different types of sequential flat files into oracle database. All these flat files are picked sequentially by datastage i.e file2 is job starts only after file1 is processed. We have noticed that the server CPU utiliz...

We have over 400 jobs now and the nubmer is expected to grow to 1000 jobs in next 3 months from now. We are using UNIX scripts for scheduling the jobs. Our UNIX scripts are now becoming overly complext as the jobs are growing. I would like to know the pros and cons of using UNIX,JAVA, Datastage Dire...

Hi , Ray , Thank you for your reply .I think I am not precise in the question.I am using field width to parse the fields and I am able to get the data in the o/p for some records .But , the problem is for some date fields , I specified the width for those fields as 8. If the records have date field ...

Hi ALL , I am using Datastage 8.0.1 version.My Job design is as below Sequential Stage --->> transformer ----> Oracle database Input File Format : 123456abcd99zzzz6789 Delimiter : none Field1 : 1234.56 ( decimal ) Field2: abcd Field3: 99 Field4:zzzz Field5:6789 Like that I have 60 Fields . I am usin...

Hi Ray, I searchd thru the posts nd found some advce regarding rights on the RT_SCTEMP dir. As suggested in this posts, I gave all the read,write,execute rights to this directory. In fact, I emptied this dir (by takin a backup) & ran the sequencer again. Bt the error is still coming for a new se...