DSXchange

Job log. The event is captioned "This job has N data sets...". Read the second if there are two - the first is for licensing.

WHY "without using funnel stage" ?

Simply create two files, and post-process in an after-job subroutine ExecDOS to type the one to append to the other.

At a job level pass the row count as a job parameter and use its value to drive a conditional lookup in a Lookup stage.

At a sequence level use the row count to select which of two jobs to run - one doesn't even have a Lookup stage.

You did not have exclusive access to the project when you executed DS.REINDEX Therefore the indexes were dropped, but not re-created. Do it again when you can guarantee that you have exclusive access and the indexes are successfully rebuilt. Execute the LIST.READU command and make sure there is no e...

U isn't undertaking this task. siddesai is.

This could be a field called something like NOTES or COMMENTS - some freeform text field into which a user has typed Enter.

No.
No.
No.
No.

The better command is where pathname is a directory on a file system with plenty of free space (at least 2GB). This gives you two I/O channels instead of one, and eliminates filling the file system where the hashed file actually resides.

Is this multi-level? Would you need to generate complete hierarchies, such as 1 2 3 4 5 6 ? That would add a deal of complexity (recursion), but could be solve using a carefully-designed hashed file and the little-known WITHIN query.

Search the forum and the manuals for the term NLS (National Language Support). Essentially the Ascential products place a character map between the data "out there" and themselves. These maps translate from the "native" encoding - for example BIG5 or GB2312 for Chinese - and the idiosyncratic UV-UTF...

... possibly the licence expiry thereof.

Check out Chuck Smith's web site - he has what you seek for hashed files, and it's easily adaptable for other OLETYPEs.

PRECISION 14 DataIn1 = TRIM(Arg1) DataIn2 = TRIM(Arg2) IsNull1 = IsNull(DataIn1) IsNull2 = IsNull(DataIn2) Begin Case Case IsNull1 + IsNull2 = 1 ; * either is null but not both Ans = @TRUE Case IsNull1 + IsNull2 = 2 ; * both are null Ans = @FALSE Case NOT(NUM(...

Welcome aboard. :D

Are you trying to import using ODBC or using a database client? If ODBC you need to have configured the DSNs it will be using, by editing a file called .odbc.ini in the DataStage Engine directory.