DSXchange

Only ODBC and UV stage types have the capability to supply multiple rows to a reference link. The OCI stage is behaving as documented.

We don't do "urgent". DSXchange is an all-volunteer site whose members post as and when they can. When you posted it was around about 3am where Ernie (WISL while you work) Ostic, our guru in all things ISD, lives - chances are he was asleep. If you need urgent help, sign up with your offi...

You say your DataStage server is a UNIX machine. Ought not your character set therefore be BIG5 or GB2312 ?

Once upon a time, in an IT environment not so far away, SQL Server was based on Sybase, and the bulk copy program (BCP) was suitable for either.

Whether or not that is still true I do not know, but I doubt it.

Which should mean that, by setting the Data Element to Date, you can get the internal format date automatically converted by the BCI (BASIC SQL Call Interface) through which the ODBC driver is invoked.

On checking the manual, I found that field #18 is the date created when executed on Windows systems. Much of my recent work has been on Windows-based servers, hence my earlier advice. So how about executing ls -cl VOC and parsing the date out of that? Does your UNIX support the -c option (date creat...

DRS can also use ODBC protocol.

A UNIX-based ODBC driver for SQL Server ships with DataStage.

Server routine idea. Test could be Until Ans Matches "0X1N"

Two Sort stages, each generating "change" columns. The first sorts by field1, the second by field1 ("don't sort, already sorted") and field2. The first generates a Key Change column, the second generates a Cluster Key Change column. The combination of these can be used to filter ...

We don't do "urgent". If you want it bad, you get it bad. DSXchange is an all-volunteer site whose members post as and when they can, if they have something to say. If you need urgent advice sign up with your support provider for priority service, and learn the true cost of "urgent&q...

No, not in a query. Direct. ProjectName = @ACCOUNT You appear to be mightily confused, however. A report from the UV.ACCOUNT table will never be the number of VOC entries selected. What - precisely - are you trying to accomplish? A list of project names? Verifying the existence of a project called P...

I don't know. It works perfectly fine for me (8.0.1 on Windows). That the format of LOC is "15T" means that its implied data type is VarChar, and therefore that '0' is a valid value. Try this. There is a directory called Template, which is a sibling of the DataStage Engine directories. In ...

Look carefully at the VOC entry. LIST.ITEM VOC 'DSX.UTILITYABORTTOLOG' This will tell you that SDK routines are cataloged with all upper-case names and "DSX." rather than "DSU." as prefix. I vaguely recall that, in versions earlier than 8.0, the SDK routines are not in DSU_BP.O b...

Apparently there are creams that you can use...

... or innuendoes (the old gags are best!)