DSXchange

First check whether you have user defined environment variable PWD defined or not? It should have complete project path value in it. Also ooking at that message, It seems you have some DS licensing problem too.

Where did you define this parameters ? I hope you had defined the parameters properly in the job properties, If not check the datatype of the parameter if it is a column definition.

In the driving table during the extraction trim those zeros with trim function either in the SQL or in the transformer derivation. Try Trim(column,'0','L').

The document is really very good. Thanks for sharing it.

sAM

Does anyone have an idea which ODBC drivers has to be utilized to access the *.mdf (Not the *.mdb) files from the SQL server Express edition through DataStage? I didn't see any ascential or microsoft drivers for this. During search on google it specifies they are supplied by Apple Inc but i am not s...

IN_COL = make_null(OUT_COL) This will replace the @null value in your source column. But i prefer using handle_null in conjuction with make_null to perform this, so as to convert it to '0' or any specific value. IN_COL=handle_null(make_null(OUT_COL),0) relatively your second function has to be some...

IN_COL = make_null(OUT_COL) This will replace the @null value in your source column. But i prefer using handle_null in conjuction with make_null to perform this, so as to convert it to '0' or any specific value. IN_COL=handle_null(make_null(OUT_COL),0) relatively your second function has to be some...

As said there is no specific stage to do this but there are plenty of posts in the forum where this had been discussed. Do a search.

Your DS engine directory is missing in the path.

Your DS engine directory is missing in the path.

As far as i remember Ascential has its own foxpro and dbase drivers and you just need to add you DSN definitions in the .odbc.ini and uvodbc.config files in your DSHOME directory.

"dsjob" is not a uv command to be executed from the administrator, it can be run through command prompt(DOS Prompt).

Did you try increasing the link buffering?

In the 8.0 release notes it is specified

Can you share your job design? it will help in getting a proper response.And as criag asked please post the the whole log entry. I had earlier been thru some of these errors but my issue had been with the aggregrator stage.