DSXchange

Ctrl-@ is the ASCII NUL character, which is used to pad fixed length strings by default. Setting APT_STRING_PADCHAR to a different character uses that character instead. For the case where SQL Server returns five NUL characters I'd be interested to know what's really stored in SQL Server. You can ce...

There's one of the obscure DataStage engine functions that can do that (System(42), but this only works on a Windows server :cry:) but you would need to incorporate some server functionality - either a before/after subroutine or a BASIC Transformer stage to be able to use that. AND be on a Windows s...

pps. The second person personal pronoun in English is spelled "you". Spelling it "u" upsets at least some of the natives.

No.

DataStage takes only one pass through the data. It can "remember" and access only the previous row.

Of course, but none as elegant as multiplying by -1.

That's a very long topic. The best way to find out is to attend the Advanced DataStage class offered by IBM.

Welcome aboard. Find information about the Sort stage in the Server Job Developer's Guide.

Think of it as the DataStage equivalent of TRUNCATE TABLE, with the additional benefit that DataStage engine can treat directories and hashed files as tables in this context.

It may also, depending on the strategy you adopt, depend on your log auto-purge settings.

Note that there are two entries in DSParams per environment variable; basically one to define it and one to store its value.

The &-based names originate in the PRIMOS operating system, where the ampersand character did not have a special meaning. The names are so ubiquitous throughout the engine code that it would have been more trouble than it was worth to change the names. Please search - I'm sure I've documented th...

DESC is a reserved word (ORDER BY columnname DESC). You can enclose column names in double quotes to avoid these issues.

If the hashed file is account (project) based you use a query language - either DataStage SQL or RetrieVe.

If the hashed file is not account based you need to create a VOC pointer to it then use a query language.

Yes, you do need to have executed the dsenv script first.

dsenv is in the DSEngine directory. You are working in its parent directory. DS.TOOLS is a menu. LISTU is an interlude to a UNIX command who. LIST.USERS doesn't exist - I did mention in my earlier post that I was not 100% if the names. Someone else may have access to them; right now I am preparing t...

Lookup returns the first one found, but still checks for others, unless you enable multiple row return from that reference input link.