DSXchange

Change

StringToDate(input,"%mm/%dd/%yyyy")

to this

StringToDate(input,"%mm\%dd\%yyyy")

Would you please post an actual date value?

What the EE stage is looking for is the db2nodes.cfg for the target database so that it will understand the partition map for a given table. The db2nodes.cfg for the database resident on the ETL server will not work (and do not change it either). Question: is rpsts1ii the instance of the DPF server?...

You are welcome

You are experiencing a conversion failure of some sort. Either the string coming in will not convert to a date or the format you have defined does not match the data.

The instance you refer to is used at runtime if provided. If not provided the environment variable DB2INSTANCE is used. This may be necessary if a database is cataloged under a different instance then is referred to with DB2INSTANCE.

Please post the exact syntax you are using in your user variable stage please.

It is not going "outside" of DataStage. It is using the tools on the palette in the sequencer and is pretty standard stuff. If the OP wants to get rid of all unprintables then something like what I posted will work or a simple C program (of which there are hundreds on the web) will work to...

This would not be something that I would do within a particular job flow by , but rather outside of the job. If you would want to do it within a job then I would create a parallel routine (pretty easy) and invoke it as a function in the transform. If you want to handle it outside using something lik...

I actually think that this is the bad data the OP is referring to, although it is difficult to discern really from the orignal post. my source data is like 2007-10-30 12:48:16.300 i have laoded in to target but data getting like 2007-10-30 12:48:16. 000 I aslo believe that someone posted and said to...

Unfortunately I do not believe that you can restore the partition to one of the other nodes and have it work. The location of the partitions are contained within the .ds header. You can certainly use a different configuration in your job then what was used to create the dataset, but I believe that a...

Can you post the actual error you are receiving? Also, there is only one (1) DB2 Connector - the DB2 UDB API is not a connector. Also, Unless you Entire partition your rows will not be "shared" across partitions. Node 0 will not contain rows from Node 1 unless you used Entire partitioning ...

Agreed, but the answer should have clarified that point. There are many times that a single node configuration is preferable to a multi node, or running an operator in the sequential mode, but without knowing a bit more from the op the answer needs to be qualified.

Run the parallel transformer in sequential way and use @INROWNUM

Seriously?

Format tab of the sequential file under Field Defaults.