DSXchange

Nice! Silly wabbits.

If it is anything like the XMLType in Oracle, you can't simply select or update it as if it were a CLOB. Talk to your DBA or google around, I would imagine there are specific sql functions you'll need to accomplish this.

BATCH_MJC_ZFD..JobControl (fatal error from KBAJobControl): Error occured getting parameter array from file - \bis_data\msg\mfr\offshore\parameters\Parameter_offshore_funds.ini By the way, this error should simply mean that it either couldn't find or couldn't open the file. Check your path and perm...

Any reason you couldn't find that in the "Connectivity Guide for IBM DB2 Databases" pdf manual?

Reread my post. You cannot do what you are trying to do. You can use a Job Parameter directly in a DB stage query but nothing you've generated inside the job. :? You should be using two jobs for this. If you need to generate a series of values and run the second job multiple times, consider either ...

Did you try Resetting the aborted job? Does any "From previous run..." message appear in the job's log when you do? I'd also be curious how exactly you are populating / handling the trigger column and if the job works if you "disable" that part, just as a test.

I'm curious how you are expecting any kind of 'upsert' mechanism to work on a single column? There's really nothing to update, all you can do is insert a value or not, if it already exists and no duplicates are allowed. The update will only fire if the insert fails, typically due to a unique index b...

I have added some code in 'Job Control'. Ok, maybe there is a need to see some code. Tell me what the heck that means. What "code" did you add and what were you trying to accomplish? Where exactly did you add it? Did you mean you edited the KBA code or you put something under the 'Job Con...

No, you didn't 'select the wrong one'. I don't need to see any code, I've got all of the KBA stuff here. Which parameter in your .ini file is part of the parameter set? All I was trying to show you was that you'll probably need to fully qualify the parameter name with the parameter set name in the i...

As noted, StringToDecimal().

... and then constrain out the nulls after that.

Why not mention that originally? So... up to 160 records per?

KBA doesn't "speak" parameter sets. It was written long before there was any such thing, so you may need to modify the "GetParameter" routines to support them properly. Before you ask, I have no idea if you'd need to do that or exactly how to do that off the top of my head and no...

Yes, on the server rather than the client. And by the way, the 'native' driver for SQL Server EE *is* ODBC, what with both being a Microsoft product and all.

Well, that or OLE-DB, Microsoft's "successor" to ODBC, but that's a different stage.

There's not much to explain other than you document / break down what the PL/SQL code is doing and then you 'code' the equivalent processing in a DataStage job.