DSXchange

You may find the following conceit useful. It applies in DataStage BASIC, please do not assume that it can be generalized beyond that.

LEN("") returns 0.

LEN(@NULL) also returns 0.

That is, Len(X) returns 0 both when X = "" and when X IS NULL.

Do you mean "UniVerse" ("real" UniVerse) or "DataStage"?

In either case you use a UV stage, but for "real" UniVerse you will need to have configured an entry in the uvodbc.config file specifying the location of the UniVerse account.

Some databases support this as DIFFERENCE. There are two possible differences between two tables, A DIFFERENCE B is everything from A that is not in B (that is, not in A INTERSECTION B), while B DIFFERENCE A you can work out.

What exactly IS the warning that is logged? Is it, in fact, from the WaitForFile activity at all, or from some other part of the job sequence? Have you investigated this fully?

Good so far, now rewrite it as a DOS bat file, as the OP requested!

You changed the question. Originally you asked about DD-MMM-YY, and my answer handled that. Now you specify that there's a time component too, which necessarily changes the rules. Iconv() won't work with the date and time in one string. Try Oconv(Iconv(Field(InLink.TheCol, " ",...

sivatallapaneni posted this at 2:45am my time, velagapudi_k demanded a response at 4:27am. If you want me to answer questions at this hour you are going to have to pay me BIG BUCKS!!! We don't do "urgent" here. Urgent replies can be had by signing up for premium support from your support provider, a...

Something else. For Oracle it is sqlldr, for SQL Server it's BCP, for Red Brick it's TMU, for UniVerse it's loadfile. Each database product has its own bulk loader. These can be invoked from DataStage, but they are, strictly speaking, database utilities. Where DataStage has "bulk load" stage types, ...

Neither is correct. When RESIZE is run within the DataStage environment the 64BIT keyword does not take a leading "-" character. Also, if you're not changing any of the parameters, it's better to use "*", since - for example - the "modulo" argument is interpreted as a command to change the MINIMUM.M...

In the RT_STATUSnnn table the invocation ID is part of the key. SELECT @ID FMT '60L' FROM RT_STATUSnnn; So much for identifying the records, what are they? There are records for jobs, active stages and resources - you have to make sure that you get them all. Start with investigating the record type....

<peeve>It's "hashed" file, please get it right! A hash file is used for filing hash.</peeve>

"Hashed" refers to the fact that keys are located using a hashing algorithm (rather than a table scan or primary key index).

Apart from that, beware of any hard-coded pathnames. UNIX servers don't understand what to do with drive letters and gets backslashes in pathnames wrong too! There is a UNIX-based ODBC driver for SQL Server, but clearly - as pointed out - that is not as slick as keeping everything in Bill's domain. ...

It's at the SERVER level. If you don't know how/where to change it, and it has been changed, then you are not the culprit. But you first need to ascertain what has changed. Just changing NLSMODE to a different value is not necessarily the fix. Has someone changed the job design, or one of the routin...

It will be announced on this site. Looking at early July, possibly 5-7 or 6-8. But it's not my call - the folks at DSXchange organize it.

Couldn't you just have specified %mm/%dd/%yyyy (or %dd/%mm/%yyyy) as the date format in the function?