DSXchange

You know this, but - you are in violation of your licensing agreement, hence the 'problem' you are trying to solve here. Two solutions: 1) Remove 2 CPUs. 2) Upgrade your license. Plus (I guess) a third - get used to it. Only one of the first two will 'suppress' the warning. Edited to add - are these...

Simple enough to test in a routine, yes? I believe you've got the syntax correct but for whatever reason I don't use that function all that much. Easy enough to test, however. The online help should say if there is specific 'not' syntax. If there isn't, you can always use the 'Not' function to rever...

All string parameters (ex DSN, user, schema) can be changed but I can't change the password because it's in encrypted type. So, the password is always the default value filled in the job. This is not true, you certainly can change the value of encrypted parameters. Their 'default' can be changed in...

You need to have a chat with your lead, as there is obviously a disconnect somewhere. This can't be about allowing you to load invalid timestamps. Perhaps the requirement is to be able to load either format. Arnd has started you down that path, both can be handled with the functions he mentioned. Yo...

Why not have a job that does this? Why do you 'need' to run sql scripts? How to do that in a single job. OCI stage does not do anything of its own. I need to add another stage to OCI to get that working. As Ray noted, a Row Generator can feed the stage. In a Server solution, all you need is a Trans...

Why not have a job that does this? Why do you 'need' to run sql scripts?

Other than for Restartable Sequence jobs, I'm right there with ya.

Try it out, let us know.

pradkumar wrote:I want to insert '2007-12-31 13:00:01 AM' into the column.

No, you don't as that is an invalid timestamp value. You either do 'military' 24 hour time or the 'AM/PM' variety, not both. Which way do you want?

dj352001 wrote:query block has incorrect number of result columns

Simply means you aren't selecting the same number of columns in each query. Period.

Any comparsion tool is going to do the exact same thing unless it is 'DataStage aware' like the process built into Version 8. So to me this would be more of a personal preference choice than anything.

Nah... it's the standard 'problem' with any routine that returns a non-zero result and the 'Automatically handle activities that fail' option in a Sequence job. Discussed here a bajillion times and documented in the online help. You need to use two triggers so that the Sequence job thinks you have h...

Like so:


Assuming a 'standard' installation location and your userid has $DSHOME set.

- If file is not found then I have abort the job and I have to send a mail saying that required file is not there. Just run the job. If the file isn't there, the job will abort without you having to do anything. To send an email in that case, you'll need to use a Sequence job to run the job and tri...

Actually, as I understand it, it would need to be:

Sequential File => BuildOp

And the BuildOp would be responsible for writing all the files.