DSXchange

Are you using an ODBC driver for text files? What happens when you click "Get SQL Info" in the stage properties of the ODBC stage?

Why are you using an ODBC stage at all? A Sequential File stage is by far to be preferred for reading CSV files.

Are you having zeroes AND tabs between your data, or just zeroes? Either way you can use Ereplace() or Change(). For example; Ereplace(InLink.TheString), " 0 ", Char(9), -1, 0) Note that the second argument has three characters, space zero space, because this is how you...

... and please note that shouting (all capitals) is regarded universally on the Internet as rudeness.

Unless Err1 is a macro (which I doubt), you can't use it as an lvalue in the way you have in the WRITESEQ statement. Try (assuming variable r2 has been assigned a value: WriteSeq "Records outputted: " : r2 Else Call DSLogWarn("Unable to write to file.", "WriteSeq"&#...

For the first file trim the trailing ";" characters. Trim(TheString, ";", "T") For the second file, convert to a dynamic array, empty strings to zero, then back to delimited. Convert(@FM, ";", Oconvs(Convert(";", @FM, TheString),"S...

Purely from memory - my current client is on Windows - the command is sysdef on Solaris.

What is the NFILE setting in your kernel? It is this value, not the ulimit value, that drives the maximum legal value of MFILES.

Yes, but Ascential will charge you just as much to supply the training materials with or without their instructor - even assuming they're willing to do the latter! And it may be the case that attending an "official" class will be a prerequisite for certification.

Perhaps not to OP?

Almost but not quite. I suspect EffectiveDate is an input value, so needs to be the Routine argument. If it's an external-format date it will need an ICONV applied to it before the arithmetic. If it's a timestamp it will need decomposition into date and time components. FUNCTION ExpiryDate(Effec...

Either way you can override from the Job Run Options dialog (Limits tab), or by using command line option with dsjob.

The figure is about right - I was recently quoted US$18000 for 12 pax for Ascential to deliver the DataStage Essentials - EE class.

I'm sure this has been covered before. Did you try a Search?

What do you mean by "log files directory"? If this is the DataStage logs, they are tables and they are in the DataStage project directory. If you have permission here then, theoretically, you could monitor your jobs. However, this would require knowledge of the internal workings of how DataStage rec...

Bonne chance! :D

Thank you for posting the solution that you found - that Access sometimes (for example when there are spaces in identifier names) requires identifiers to be delimited with square brackets.