DSXchange

Note: But i have to maintain Those column names as same in target, source, and refrence No you don't. You can change them (to get things to work) and reinstate them downstream. Check that RCP is not enabled in the job and in the Lookup stage, even though you state that it is disabled as a project d...

The order is not correct. Also, stage variables in parallel jobs can not be null. svCol2NotNull <== NullToValue(inlink.col2value,"<<NULL>>") svIsChanged <== svCol2NotNull <> svPreviousValue svPreviousValue <== NullToValue(inlink.col2value,"<<NULL>>") svOutputCol <== If svIsChange...

Just as a test, create a brand-new, empty project and try the import into that. Make sure that you specify "overwrite without query" and do not select "perform usage analysis".

Use the Data Set Management tool, from the Tools menu in Designer or Director.

(There is a command line equivalent called orchadmin - you can Search DSXchange or the manuals for more information about this command.

Is there anything useful in the job log for the OutBoundInterfaceIRS1099_CreateFile job?

Did you create a "parallel routine" entry in your Repository to allow DataStage to find your code at run time?

There's also a training DVD at DSXchange Learning Center on the various uses of the DataStage BASIC programming language.

A future version of DataStage (probably the next) will not have a Loop stage in jobs. It will have the ability to set up a looping construct within a Transformer stage - and consequently the ability for the Transformer to sent more rows to an output link than were received on its input link.

Stage variable has to be overwritten when the change key (generated in upstream Sort stage) is set, or accumulated otherwise. Let's call the stage variable svOutputRow If inlink.changeKey = 1 Then inlink.col2value Else If IsNull(inlink.col2value) Then svOutputRow Else If Len(svOutputRow) >= 20 Then ...

Is NLS enabled? This byte may be a leading byte in a multi-byte character.

When ODBC protocol is used there are default maxima for the number of columns and size of rows that can be transferred. These can be overridden either globally or for a particular data source name by editing the uvodbc.config file and setting MAXFETCHCOLS and MAXFETCHBUFF parameters. The MAXFETCHBUF...

Server shared containers do, because an interface has to be constructed to pass data to and from the "datatype free zone" that server components are. However, that ought not to have anything to do with generating "User Id is a required stage property" error - this is either cause...

First verify that the various tiers (services, ASB node, engine) are correctly started.

Does the "no link to overflow group" in DS_JOBOBJECTS still occur? (This would mean that the problem existed before you backed it up.) Run UVFIXFILE against DS_JOBOBJECTS and let us know the results.

Did the file system on which DataStage projects are installed become full at any point?

Provided everything is installed with precisely the same pathnames as previously, you should be able to restore from backup and continue operations. Note that this advice applies to project directories, which was the question you asked. Backups of the respository and of the WebSphere app server, tha...