DSXchange

Hi ,

I want to pass 4 distinct values from a data base table to a Sequence job.
I have defined 4 parameters to catch the values.
Is there any method to read and pass it to the job parameters.


Thanks in Advance!

Hi All, I've had a search through on this, but couldn't find anything using the parameters I used. Basically, I have a few jobs that I exported from a v7.5 server and imported back into a v8 instance. The job displays fine in v7.5, but when I open it up in v8, the icons are smaller and font on the l...

Perfect - thanks Mike.

Cheers,
S

Got it! :) We didn't used to have NLS installed on the old server, but have it with v8.01. The default date under this option was set as US-ENGLISH. Changed to GB-ENGLISH and it now works. I will change the routine to explicitly expect input date of DD/MM/YYYY. Hope this helps someone else at some p...

Hi All, I have a BASIC routine that was working happily on our old v7.5 instance on DataStage. It looks like this: WorkDate = Iconv(InputDate,"D/E") Ans = oconv(WorkDate, "D/MDY[2,2,4]") Basically, it takes input date in the UK accepted standard format and converts to the US form...

:oops: :oops: :oops: :oops: A matter of user error I'm afraid. I had one of the directory parms set up incorrectly in the jobs - so it was looking for the .ds header/pointer file in the wrong directory. There was a IdMasterDataFull.ds in the 'incorrect' directory, but a previous clean-up had removed...

Hi All, I have searched extensively for this, as I thought it must have come up before, but couldn't find it, so here goes... I have a job that runs a number of times, parsing XML and appending to a dataset as output. That dataset is then opened up in a downstream job to write to a DB. The parsing j...

Thanks for the input Ernie, much appreciated.

Regards,
S

Thanks sud for you time and input. I'll give it a go.

Best,
S

A rather crude way of getting the file to look the way you want to be able to chunk it (it looks hilarious since I am particularly poor at sed and awk): sed 's_<[A-Z]_*&_g' testxml.txt | sed 's_</[^D]_*&_g' | tr '*' '\n' testxml.txt is your xml file. This will basically render your file in ...

Hey sud - thanks for this, it's an approach that I hadn't really considered, so will see if I can fit it in. I am interested in the build-op technique, and (due to the type of xsd's we use not working well with DS meta data importer - long story, different thread) I am using manually coded xpaths, s...

chulett wrote:I personally think generating files of that size is... well, just wrong and doesn't do anyone on the receiving end any favors.

I have to admit that those words have echoed around my head more than once.

Cheers,
S

But the point is how shall I map this to the Output of the XML Input stage to get the data? Same way as you would with the Input XML stage using the Folder in Server - map using xpaths declared in the description field of the table definition. All detailed in the XMLPACK guide in the DataStage docs...

Hello All, I have a requirement to parse multiple XML files, many of which are over 2Gb in size. As many of you will know, due to the way in which DataStage handles XML parsing, there is a limit on file size, and when that is breached, you'll see the jobs abort with: APT_CombinedOperatorController,0...