DSXchange

Use the orchadmin cp command from UNIX to copy datasets. By using a new APT_CONFIG file you can also change the location (and amount) of data files.

There is no particular reason for '7' references. What I will do with a particularly complex transform stage on a multi-cpu system is monitor the %CPU of that tranform stage. If it is close to 100% then the job can be made somewhat faster by splitting into 2 transforms stages (assuming interprocess ...

If your are not using that column in a constraint or in a stage variable and you are certain that each use in a derivation is handled as you have described then you have discovered a bug.

I played around earlier at work and couldn't find a way to do it. You might try to take a look at the dscmdexport.exe in your favorite binary editor and find the constants section and search that for a possible command line option for xml. Failing that, I'd go through your support provider and see i...

I've gotten this error before when I was certain that I'd dealt with nullability in all occurrences of the column in the transform stage... then I discovered that I'd used the column in a constraint. Perhaps you might have the same problem.

The filter needs a data stream (stdin) to work with. I'm not at DS session now to check, but it should work with "gunzip -" or, failing that, use an external command stage to perform the compression or decompression.

I don't know if that is what the poster wanted, but I didn't realize that PX would supply the 3 digit month acronyms {I wonder if PX handles locales as well...}

No, there is no single function call which will do this, which is why Maveric proposed his solution. You can get the month number then do a single to get the month string.

I would recommend stopping and starting DataStage.
Do you have multiple engines running on the same machine (i.e. connecting to client via a port number)?

Are you running jobs using the same user id from the Director and from the command line? Also, do you have several projects and if so, please try to see if you can use the dsjob command to list the jobs in another project on the same machine.

That is quite strange. And can you start jobs from the director as well? Is the system very slow and have you tried stopping and starting DataStage?

Referring to my original post - have you set your user environment correctly? go to $DSHOME and issue a '. ./dsenv' and if you haven't included the dsjob in your path it can be executed in $DSHOME/bin/dsjob

And the 2nd part of the question?

Gomez - you will need to produce some code to do this logic. There are many different ways in which people have done this. If you can modify the files in that directory once you have picked them up (i.e. chmod to remove read access) you can use simple UNIX commands to select only those with appropri...

If you do a "save as csv" in Excel you will get a comma separated file, and any columns that contain embedded commas will be double-quoted; so you will get a well-formed CSV file. You can read that in DataStage without a problem. Could you explain ...I tried to change the ',' in the file to "|" but ...