DSXchange

When calling a job using the dsjob command line interface, specify "{JobName}.{InvocationID}" for the job name.

Since you haven't posted the UNIX command string when you pass in an argument there is nothing that can be done to help.

I think that you should find a Job titled something like "RemoveOrphanedPXFiles" somewhere in the project that you can use to do this for you - this isn't a standard job but one that I wrote & installed. What it does is traverse the WHOLE system looking for PX files (this runs a long time and yo...

Just on your PC or on any? I would recommend re-installing your client.

Try adding a parameter with a unique number passed to it from the sequence and use that as part of the sequential filename. Then check the files for each run to see if they match what you expect; this might help narrow down the issue.

Ahh, I think I understand now. Does that mean if a run produces no output then it uses the previous run's file again for the Oracle load? Can you check to ensure you do have the "overwrite" setting on in your output file? Also, what version and platform are you on?

In the manager do a Import -> Table Definitions -> Plug-In Meta Data Definitions and choose your DB2.

Have you declared this as a multi-instance job and are calling it concurrently with different invocation IDs in the sequence? If yes, you need to ensure that the sequential file is different for each instance - hint - use the invocation id as part of the filename.

s_porkelai - whyever not?

What stage do you have feeding the reference in the lookup? I wonder if it is Oracle - which only knows about number and not integer types. On the other hand, I am using DATE (well, timestamp) columns for lookups right now without any issues at all - but I am not redefining them as INTEGER(10).

Ray - Ahh, missed that. As you noted, often the first line returned from the execute command is empty.

The Field function is qutie versatile and powerful: FIELD({StringToProcess},{Delimiter},{Position},[{NumberOfFields}]) So for String = "Hello World, All your base are belong to us." FIELD(String,",",1) would be "Hello World" FIELD(String," ",5) would be "base" FIELD(String," ",6,2) would be "are bel...

Since you are logging the UNIXcmd variable in an informational message, could you post that output for a run that doesn't work? The output goes to stdout, so perhaps this command is returning nothing to standard output...

So the RHS column is trimmed correctly, and that is what you are passing on to your output stage where the blanks are being added in again? This would only happen if you are going to a fixed width CHAR field - are you sure you aren't doing that somewhere? Are you using user-defined SQL and, if so, a...

Siebel is the CRM system sitting on top of a database - probably DB2 or Oracle. And what happens in the PEEK stage with the trimmed field?