DSXchange

No.

That would getting into Cartesian product territory. "They" thought that that would be a Bad Thing.

You can use more than one Lookup stage. But you still risk generating a Cartesian product.

No idea. Disable operator combination, either globally or in particular stage(s), to find out which stage is actually throwing the error.

What query did you use? I suspect you got it right - you can override the column heading ("Reserved" is the default column heading). And, yes, job type is enumerated: from memory they decode as 0 = server job, 1 = mainframe job, 2 = job sequence and 3 = parallel job.

Server job (as marked) or parallel job (as posted)?

What do you want to get that the DataStage API or ETLStats does not provide?

FTP stages do not transfer files. They transfer bytestreams; your job reads from or writes to the bytestream directly. If you want to transfer files create a BAT file or shell script and invoke FTP from that.

Provided that the metadata is in the correct format you can use the Schema File property in the Sequential File stage that reads the file.

Help yourself. Search - parse and pivot.

DateFromDaysSince() function

Perhaps your driver does not properly support LongVarChar. Try using a different client, perhaps MS Access, from the DataStage server.

1. Search - both the DSSetUserStatus routine and an interlude function exist on DSXchange.

2. Yes.

Use LongVarChar. Under ODBC standards the maximum size of a VarChar is 255 characters.

All complaints to billg@microsoft.com (because ODBC is a Microsoft standard).

Here's what I got running it through the SQL Navigator formatter. Note that there is a space ahead of the DATENO alias name. SELECT hierarchy_id, employee_no, (SELECT CAST (dateno AS INT) FROM owner.date_hierarchy_dim WHERE TO_CHAR (external_date, 'YYYY-MM-DD') = '2008-09-03')...

Premium membership is one of the ways that the hosting and bandwidth charges incurred by DSXchange are defrayed. There are only five premium posters. Membership is not expensive, at less than 30c (Rs12) per day. No premium memberships = no DSXchange. It is for this reason that the premium posters w...

Make sure that your record schema matches what's actually in the file, or vice versa.