DSXchange

Oooo! Oooo! [raises hand] There's two more keys?

Program "JOB.1518842743.DT.1420153957.TRANS1": Line 279, Improper data type. Have you looked to see where this is in your job? The error message will have mentioned a job number so you won't have to look it up from the job name. Go to your Projects directory and into the particular project for your...

I'm sure there are parallel functions you can use, others would need to help with that. If you want to pursue a Server / BASIC Transformer solution then I'd suggest you look at the DateGenericToTimestamp sdk routine. It illustrates how to handle those Ordinal dates (what it calls 'Julian Year Days')...

Thanks... hopefully these kind of things become web service calls under 8.x, or at least simple repository queries. Simple being a relative term, of course.

I've never seen this option work, was curious if anyone else did? Just today tried to use it again and noticed that the moment I enabled it I got an 'Error on page' warning down in my status bar. Hoped this might help someone brainy like Walter to get it working. Line: 391 Char: 1 Error: 'document.f...

Something I've been wondering about - when you attach to a job in custom job control, how can one tell that the job is in an 'Aborted/Restartable' status rather than just 'Aborted'? I don't see anything related to JOBSTATUS in the dsapi.h file that seems like it can be used for that. I've found that...

Clarify something. You've posted in the Server forum but marked the job type as Parallel. Plus you've referenced a function that sounds an awful lot like the sdk transforms that come with the Server product. Just want to make sure which job type this is in reference to. Also, it would probably be pr...

That's all? I would think you would see all the 'normal' sqlldr information - like this, just pulled from a scripted call to sqlldr: Table X: 6903274 Rows successfully loaded. 0 Rows not loaded due to data errors. 0 Rows not loaded because all WHEN clauses were failed. 0 Rows not loaded because all...

Paddu gave you an example of the syntax.

Seems to be alot of that going around suddenly.

If you concatenate a single NULL value anywhere in your collection of fields, then the end result will always be NULL. So, ensure that none of the fields can be NULL. I've found that the NullToEmpty transform works wonders in situations like this.

And where exactly did you get this DateTimeDiff routine? Ask the author, it doesn't come with DataStage... did you find it here somewhere?

TOAD will let you do it if you've purchased the DBA Module. Better to just ask a DBA directly...

Stick with a Sequence job - and enable checkpoint restarting in it.

I am getting the following error for a scheduled job. Jobname..TransformerStageName.LinkConnectingTransformer&ODBC stage: DSD.BCIPut call to SQLExecute failed. SQL statement:DELETE FROM sysdp.dbo.SpData WHERE (batch_id = ?); If there is nothing to delete, some databases will return a warning. T...