DSXchange

I get the following warning when using string_from_timestamp function in Modify Stage Input COlumn is "dt" of type timestamp Output is "dt_1" of type VarChar Specification is dt_1:string = string_from_timestamp(dt) Where do i specify a format string?Documentation is not really he...

Does it mean the existing UV metadata engine is going to be done away with?


Thanks
Ramesh

Do a google on "Universe ODBC guide" and it will lead you to quite a few other useful documents.

HTH

Ramesh

The Basic Command only works with UNIVERSE Files. For Sequential files you would need to read the file, skip the first row and write to a temp file. Then delete the source file and load contents of temp file to a newly created file.

Try this

:D , The last time i got this error, all freestanding files in my $DATASTAGE/projects/ProjectName directory had been deleted, apparently by a stray semicolon in the filepath of a sequential file being written to the project directory :D . An ECASE has been raised to IBM. LOL This happened only for o...

I had to read filenames from a UNIX folder and process them in the order of file creation time and i used the follwowing command to return a space delimited list of filenames. This list was used to trigger a list loop with space delimiter. For each counter value, tehre would be one filename, This fi...

Yeah a file delimiter cannot be specified as a parameter. The only way to work around this issue is to read all columns in the file as 1 column and split it in a transformer stage , using the delimiter in a Field() function, that does the column splitting for you . Only in such a case , can you para...

Ensure that you have a job activity stage in your sequencer. We faced a similar issue when we did not have a job activity stage in our sequencer and fixed it by adding a dummy job activity stage pointing to a dummy job in the sequencer.

Reminds me of a seemingly crazy requirement to write a custom 'log file', apparantly for 'easy readability', as if the data stage director log is in hex.

OpenSeq PathName To F.Var Then Loop ReadSeq Dummy From F.Var Else Exit ;* at end-of-file Repeat WriteSeq ReportText To F.Var Else Call DSLogFatal("Cannot write to ":PathName, "MyRoutine") End End Else Call DSLogFatal("Cannot open file ":PathName, "MyRoutine")...

Kduke, Maybe you are right, i guess data stage doesnt have anything in Universe above version 9.6. The XML example that we failed to generate from XML output pack is a fairly simple one from an XML perspective, considering all 'complexities' that are inherent in XML. Fact that XML output pack doesnt...

Have you tried reading the input file from a folder stage, and passing its contents as the XML source column? We have quite a few jobs doing the same and it works fine.Has Xpath expression been defined in xml input stage column definition.

Yeah , i do concede , it would be easier to 'build' the XML in a transformer stage variable and pass it as an XML data element to the output XML pack under the parent element. That way i wouldnt be using those dreadful 'UV Skillz' or custom coding. For UV Skills and XML : http://publibfi.boulder.ibm...

Appararently the JDOM API seems to have simplified their task. And java experts are easier to get than UV Basic ones.