DSXchange

What driver have you specified for the particular DSN?

1) You are relying on an implicit conversion from string to decimal, and are being alerted to this fact. Use explicit conversion to avoid the warning. 2) You have specified XXX_ID as a key in the sort-merge collection algorithm but that field does not exist in the record schema of the inbound record...

This may not be it but there are three quote characters in

Make both the input field and the output field Nullable. This is the right thing to do if they're going to have null in them.

Typically the descriptor (*.ds) files are not stored on the resource disks - the pathnames on the resource disk(s) are stored within the descriptor files.

The first error (signalled by ##E) is "This field was not found: Link_SKG_Xfm".

xch2005 wrote:In addition to previous post, if I remember correclty the input excel needs to have only 1 sheet.

Thanks

That is not the case if you use ODBC. You create a DSN to point to the workbook; each worksheet is a "table" within that DSN.

You'd need a loop in the UNIX script to access each project in turn, and to install the DataStage BASIC routine in each of those projects or globally. As a general rule global cataloging is not a preferred approach in DataStage but it is, however, supported. Details can be found in the DataStage BAS...

There is only one solution, the obvious one. You need to be granted the appropriate credentials for Information Server. Are you really sure that the user ID you are using has Information Server administrator role? Is there a second (spare) Information Server administrator user that you can use?

" " is not a valid date, which is why DataStage is handling it like that. You need to intercept the spaces value and replace it with some valid date, such as 4000-01-01, or declare spaces as the Null Value for that field, before converting the data type.

Setting this property causes an additional column (called "keyChange" by default, though you can choose any name for the column; the column name is the value of the property) to be output from the stage. You are propagating this additional column through to your database table, but no column called ...

Create operating system groups, one per project. This is a Windows administration task. Add users to groups. This is also a Windows administration task. Protect the project directories and all file system objects therein such that its group has all access and others have read-only or none. This can ...

Then search the forum for how to use BCI functions and get them to have to pay for a DataDirect driver!

Use a different sequence name. The sequence name is the argument to this routine. You are using a sequence named "1" in both jobs. Don't.

(Thinks: I can has cheezburger.) Define "performance" in an ETL context. In what meaningful way can the adjective "heavy" be applied to what you have defined? A system DSN is required because a user DSN is only accessible to whomever creates it. In any case, there is no such differentiation on UNIX;...