DSXchange

Iam kind of getting that , correct me if iam wrong here , if i use wait for file activity i can look for appearance of the file and timeout after a certain time .that way will be a way to distinguish if the file exists or not right ? ... Is that possible to add logic for branching in that case ? or...

Sreedhar - just leverage the 'test' capabilities your shell. For example, for korn: if [[ -d ${DSHOME} && -w ${DSHOME} && -x ${DSHOME} ]] ;then Meaning: Is the $DSHOME 'file' a directory that is writable and executable by the current user? Do a 'man' on ...

Now that it's available and all...

Something like this? Can we get an 'exactly like this' sample?

I am unable to use the merge stage as it requires a key to be defined for joining , which is not present in my case . I require the SQL select A from B and C from D to generate the output file. This doesn't help at all to explain your requirements. At a high level, let's say your two files have rec...

Actually, no you can't. Not technically. That's the nature of sequential media. You'll need to read the entire contents of the file each time. However, each instance can choose to process a distinct portion of the file in parallel. Or you can chunk up the original file and then process the chunks in...

Part of the problem is that being an unbounded Number in Oracle it can hold a wide range of values. Yes, it certainly can. Some rows have 32 digits after the decimal point whilst the biggest number in the table has 8 digits. Therefore if I specify as Decimal(38,32) I end up dropping the values that...

Use the UNIX command cat file1 file2 > file3 You don't need DataStage for this one. Basically the requirement is cartesian join between two files. Make sure this is really what you want before you go further down the path - a cartesion join. Reread Ray's explaination of the difference as it is tota...

No, don't know of any. I find a good reference book and the occassional Google get me by... that and the help of any local uber-scripters.

And as long as you don't get all crazy on us, we'll help here too.

Invoking a Wizard is generally considered risky... best not to anger them with unreasonable demands. Even if you do get this 'some help' I don't see how it's really going to help. The functionality you seek isn't available if you are expecting to be able to handle this kind of information 'on the fl...

Change the metadata to what it should be. As noted, Decimal(38,10) is the default for a unbounded Oracle NUMBER - correct it. Should fix the OCI error part of your issue.

kduke wrote:You are welcome Craig.

Umm... thanks!

Anyone any suggestion? As noted earlier, contact your Support provider. See what they have to say about the issue. Since it's not using true 'command line' sqlldr in Automatic mode but rather a direct hook into the database via the API I am still under the impression that it should be able to handl...

sudharma wrote:DSJS.RUNOK OR DSJS.RUNWARN

No. If you think that is working for you - it's not. That "expression" evaluates to TRUE 100% of the time.

You absolutely need to provide an expression - like "X = Y" - in order for it to resolve properly.

dsedi wrote:Is there a way to accomplish this with some options without actually appending the + sign?

So far, it looks like the answer is 'no'.