DSXchange

My Oconv returns date like this 2004 08 20
Then this should work fine too:
Trim(Oconv(LinkName.DateColumnName, "DYMD[4,2,2]") , Space(1), "A")

But the question is: what is your input value look like?
Oconv input shoud be integer.

What Michael is saying is it should be 4 arguments so guess one. Call DSGetLinkMetaData(Result, JobName, LinkName, X) and print out all the arguments afterwards. I tried that: Code: Call DSGetLinkMetaData(Result, JobName, LinkName, X) print "JobName = ":JobName print "LinkName = &quo...

Hi I was trying to fill all the null values in a Oracle table with # sign which is the default setting in DS designer. But once i run and look at the output in the oracle table the table still displays null values. I dont know whats wrong.Is there a way to do this? Did you look using DataStage brow...

I am sorry. It is not an answer to my question. Did you try to answer somebody else? A rough check on line length might suffice. Line length is the quotient after dividing characters in file ( wc -c file ) by lines in file ( wc -l file ) which you can do using the UNIX command expr . Check out the m...

Yes, I would like to have a data file with a file format. But I would like to get file format dynamically at runtime. Knowing a job name, a file name and a link name is it possible to access the job design at runtime and dump the file map into sum file where I can grep on field name and get a displa...

I am working with flat fixed length ASCII files in UNIX. I have the non-DataStage processes that need to know the current file layout (field name, start position, size). I would like to be able to retrieve this info dynamically from the most current version of a Data Stage job that creates this fil...