DSXchange

Doesn't MONTH.LAST do leap-year checking?

Don't know how to do it with iconv/oconv alone, but you could write your own routine without too much difficulty. - Extract 3 numeric vars from your date: YYYY, MM, and DD. You can use iconv/oconv for this - search for "d code" in the online help. - Add n/12 to YYYY - Add mod(n, 12) to MM ...

That must be because you are using the dreaded 'Automatic Mode'. Yuck. There's a lot of Auto-mode-bashing goes on in this forum. What's that about? I like auto-mode. [rant] If your transformation is a bit on the pudgy side, then you can slip an IPC just before the OCI Load without slowing the trans...

I would use a SEQ file stage to dump data to a file rather than the Oracle BULK loader. My reasoning here.

I pretty much did the same thing but in my case i even needed 2 OUT parameters. It gives me error and there by aborting the job. ... I would be surprised, nay flabbergasted, if you could pass OUT params from a stored proc back to DS using the Before/After-SQL. If you MUST use a stored proc to suppl...

I've tried that before. Before and After SQL run whether there are rows or not. I've done much the same as the previous suggestion, except instead of parameterizing the entire DELETE/TRUNCATE, I have a PL/SQL procedure that conditionally truncates the table. PROCEDURE truncate_table ( pTab IN USER_T...

I took a slightly different approach. Rather than join to the target in transform, I transformed as if everything was an insert, even though some of these rows would eventually fully replace existing rows. The target of the transformation was a flat file. The object was then to MERGE that flat file ...

Sorry Craig, as a skinflint member I only got the first 3 lines so I don't what the question was (if there was one). If it's any help, we had VC-Bloat as well. Stupidly did a few bulk-initialize operations pretty early in development. Since then, lots of stuff moved, renamed and deleted. I blew away...

We had the same problem on 7.5. I don't recall how it was fixed exactly, but I think it was this: We created the variables initially as STRING in Administrator and changed them to ENCRYPTED after having included them in a number of jobs (which stopped working). To fix it, we may have removed the var...

Also worth noting that if the OCI Load stage ceases to "support" SQL*Loader then we are hardly any worse off: - You can only use delimited format - You cannot choose a non-printable delimiter (eg. TAB) - It does not produce proper CSV format (quotes are not doubled) - And if your data cont...

Followup: For anyone interested, I wrote the following routine called "RestartJob" that is no less nasty than it is cheap. It takes a single argument: pJobName - the name of the Job/JobSeq to restart. It does the following: - Finds the job - Finds the previous settings of parameters - Sets...

DataStage can use only one Oracle client, so work out which database you want to use OCI Load (Automatic) on, and set the $ORACLE_HOME of that DB version in your $DSHOME/dsenv file. You will not be able to perform OCI Load (Automatic) on the other database. If you don't want to use OCI Load at all, ...

There is no source "database", it is just a source "client". For example, say your target is an 8.1.7 database, and you are trying to load from a machine that has only an 8.1.5 database installed. All you need to do is a minimal installation of 8.1.7 on the source machine. You do...

I really should spend more time in the options window...

Some links in Job Sequences are coloured in Designer, viz OK links are green, Conditionals are Blue, Failed are Red. Otherwise and Unconditional are both Black. Got into a nasty bind the other day: Normal pipelines of activities use Unconditional links, with the "Automatically Handle Activities...