DSXchange

Issuing a call to DSLogWarn() does not trigger a job failure, that's what DSLogFatal() is used for.

This is easily done by storing the value in a transform stage variable and then using that saved value for comparing the next record. ComparisonStageVar = In.CurrentRowColumnA > PreviousValue PreviousValue = In.CurrentRowColumnA These two stage variables show how such a comparison could easily be do...

Is this "xxx" a DataStage hashed file accessed as a table or is it in your source/target database? If the latter it would explain why you are getting this error message.

You can use the method you suggested and use the @INROWNUM variable as a key to rejoin them after processing, or just declare additional columns in the input file that aren't used, just mark them as "incomplete column - retain" and don't use them for the record formats that don't use them.

If you do not need the Header/Trailer rows then just ignore them (drop them in a transform stage). If you need some data from a Header line, put it into a stage variable in the same transform stage where you drop these rows.

Marked as Server in the PX forum. Who knows which it is... Only the shadow knows

ICONV() won't work in a PX job. So you will need to convert this string date to the correct string format then use StringToDate() or a similar function or use the cast capabilities within your Oracle query.

DSGuru2B - Those beasts are dinosaurs compared to what is available today. It is similar to marveling at the old steam powered factory machines - there is a certain nostalgia associated with the old heavy iron, but you wouldn't want to revert to having to actually use them. I know I still have an IB...

Craig - we used to have a program that we could run on PRIMOS and our old IBM 90Mb disk drives would "walk" across the floor - the program timed the heavy disk read/write heads to move in just the right frequency to shake the drive enough to move it around (if you did it too long the power or data c...

That isn't the way it would work. Since "UNLOCK" is a VOC command, the way that this could be audited would be by changing the contents of the original "UNLOCK" to call a program that would perform some sort of audit trail writing and then issue the actual UNLOCK command from there. This would be th...

Derek,

##W TBLD 000000 21:08:07(005) <main_program> Error when checking composite operator: Output from subprocess: sh: /usr/vacpp/bin/xlC_r: not found.

No c++ compiler?

I used to love the speed and sound of a high-speed Printronix belt printer and was surprised last week to find one still hard at work at this site! I recall (not so fondly) of having to clean and maintain a couple that we had at college a couple of years back... they always did get very grimy with a...

Wolfgang - I can go anywhere where EasyJet or another el-cheapo carrier goes from the UK I was thinking of taking time off for Fassnacht as well and seeing what it is like in Trinidad and Tobago and I bet that if Georg weren't so busy with his local Karnevalsverein I'd invite him for a "Real" Mardi ...

Then it is the Oracle definition for the column is the one you want. Is it different from the SQL Server one?

... The record could not pass through Datasatage transformer being used...The warning message is from Datasatage and not Oracle... DataStage Server transform stages do not limit the length (or even contents) of columns; the error message is being generated when DS tries to output to SQL Server. As ...