DSXchange

That's because you're not in any Project. Either execute the command from the Project directory itself or LOGTO the Project first and then execute your SQL.

Many years ago, when RTI (former ISD) had a set of web services for standard Job Control, a PDA based Director was developed.....but it didn't get used and the Job Control Web Service [and hand held Director that used it] was deprecated. That is what I saw... many many moons ago, demonstrated to us...

Gotcha... always good to include a link as the one I found was something completely different.

Hopefully what you have isn't in Korean.

I seem to recall from one from many moons ago that was scrapped. Wasn't aware of this one... and (as suspected) it has nothing to do with DataStage.

There's no need for two conversations on the same topic. This one wins.

See if this helps.

What output do you actually get? What is the data type of your target column?

Technically, yes - as long as the number of bind parameters in the SQL is equal to the number of columns defined in the stage - which is what the error is saying. Note that (at least in the past) the ODBC stage doesn't care about that little detail.

Exactly.

Or at the very least, as requested, details of how you are 'fetching records'... how is the stage configured?

Note that (in spite of what the illustration seems to show) there are links from all three jobs to the Sequencer, hence the need to set it to Any for it to work properly.

So... we're supposed to guess what exactly it is you are doing in the stage?

Wowzers... that brings back memories.

Of course. Figured those details were more applicable in another discussion and here we were fine with a simple 'yes'.

Yah... that one too.