DSXchange

We have two posts on the same topic. We really should stick to one or the other.

http://www.dsxchange.com/viewtopic.php?t=122147

Your first stage should be a Folder stage, not the Sequential. How did you generate the metadata you are using for the XPath Expressions in the XML stage?

You can script this using 'dsjob' or write a routine to loop through the jobs and get a list of parameters. And no, it won't take much time to run but can hang if you don't skip the job that is doing the work.

I've already explained both the problem and the solution. Why do you need custom SQL when the generated SQL works for you? What changes are you making to it? If you want specific help, you'd need to provide specifics: 1. Number of columns defined in the stage 2. Which are Key columns 3. Your SQL

Started 4 topics, not a single response back yet.

Please be more specific.

If the file does not have a header record, then setting the stage to 'First line is column names' will cause the first record to be skipped automatically. Make sure you annotate that on the canvas if you go that route.

hh:nn:ss? nn? Am I missing something or did you mean hh:mm:ss? And what are you planning on doing for a date... or did you mean an Oracle INTERVAL field rather than a TIMESTAMP?

i think beacause of $sign, i am not able to pass the config file. No, it's because each parameter name/value pair must be prefixed by "-param", each and every one. You need iterate thru the file and concatenate a string together so that you end up with: -param InputDir=/home/source/ -param OutputDi...

Check the various options for 'dsjob', there are equivalents there for all of the functions you can use in jobs. Server Job Developer's Guide, Command Line Interface chapter or the usage help in dsjob itself.

For example: dsjob -jobinfo

Kshitij Rawat wrote:If I used Sequential file it is not allowing gunzip -c command.

That's what the Filter option is for and where the gunzip command would go.

You can't trim spaces from a CHAR. You need to fix the problem the first run caused, update those fields in the Oracle table to get rid of the pad character you used the first time and get the spaces back that it expects to be there. If you trim them from the existing data, the spaces will come. Aut...

Only if you give us a better idea what 'getting aborted' means. UNIX uses two different schedulers - 'cron' for any kind of repeating schedule and 'at' for one time runs. Your scheduling user would need permissions to both (entries in cron.allow and at.allow) in order to make any type of schedule. I...

Search is your friend!

"ds_ipcput() - timeout waiting for mutex"

It's on the Client CDROM in the Unsupported Utilities directory, from what I recall. However, I did make use of it once and it worked fine. Of course, there's a README that explains how to use it.