DSXchange

If you know the exact no. of jobs, you can achive this by having a master sequence. But not sure about the job in not compiled state.

Btw, what is the use of having jobs in not compiled state in PROD and also the count of them? how does that matters?

Thank you guys for the reply. I'm not able to read it fully though. But I will try with the schema file and let you all know.

Is there a way to create a job which reads in any MF binary [EBCDIC] file by providing the copybook dynamically?

The copybook may have COMP/COMP-3 fields or may not be.

I need your valuable suggestions to create a Job/Routine [PX Or Server] if at all this is possible.

battaliou wrote:Er, you're trying to put NULL into a sequential file? Good luck.

Why do you think it will not accept NULL. Seq file will accept NULL.

Or call your pl/sql statement from a DS job

I believe he wants to write the header in all of his pages [??].

Cant you include the header detail to your Pages 2 & 3 as you do it for your page 1??

If this is not what you are looking for, please post more details.

Best way is to do the delete in a sep. job.

Thank You! ArndW...

I will go for the Built-In, Not grown that brave yet

Hi,

Is there a way to read datasets using a DB stage as we do for a hash file with UV.

Read your Hashed File in a UV stage and look it up... Multi-row lookup will not be enabled for a HF lookup..

i have job like dataset 1 -- > transformer ---> sequential file. let say dataset 1 has data like a,1,2 b,1,2 c,1,2 Now i wish to create three files named a,b,c and a will contain record a,1,2 b will contain b,1,2 and c will contain c,1,2. Some way i have to pass col1 values as paramter to sequennti...

pillip wrote:Hi,

Do we have any limit on the size of the XML file which can be written from Datastage.


Thanks,
Prasanna

Not much sure about the size limit but have created a file with >500MB. Only thing is that the job ran for 4 hours.

Hi I am trying to create one parallel job where we will read one XML file as input into a XML input stage for further processing. I used one sequential file stage where we read that entire XML file "test.xml" as a stream input into one single column "XML Record" of that sequenti...

You can use sequential file stage and define your column as LongVarChar - 999999999. This will work.

Thanks for your reply. the problme is resolved. Actually we use to get the file name from a common hash file thru UtilityLookupHash. The file name had a space at the end...