DSXchange

By the way, anyone got a patch number for the patch in question handy?

-> Richard

Thanks for the replies. Our main IBM contact person is off this week, so we'll definitely be following up with them next Monday regarding patches and suggestions. Just thought I'd try and do a little digging in the meantime. Breaking down the sql in pieces really isn't an option. The actual sql vari...

I'm guessing there has to be a simple answer for this, but after looking through the 8.0 documentation and going buggy-eyed from forum searches, I'm not finding anything. In a nutshell, I want to pass SQL as an SQLPARM to a job, and have that show up in an odbc stage in the job in the select stateme...

Folks; Here's the skinny. We have a routine that runs every morning, which calls a parallel job. In that routine, here's the bit that actually is kicking off the job: errStatus = DSRunJob(hJob, DSJ.RUNNORMAL) errStatus = DSWaitForJob(hJob) JobStatus = JobFailedCheck(DSGetJobInfo(hJob, DSJ.JOBSTATUS)...

Sud: I could certainly access the database and get a row count, that's true. But since I'm already pulling the rows into DataStage, I was hoping to minimize the need for any major change. I was hoping to just be able to make a few minor modification to the existing job and be done with it. CCatania:...

Does anyone have an elegant way to do this? I have a job that pulls data from a database, runs through a single transform to do some formatting, then writes to a dataset. I would like this job to abort if the number of records passed is less than a certain amount. I just don't see any way to make th...

I suspect the answer is no, but is there any to define a Sequential File such that DS ignores line breaks, and instead uses a defined string as a terminator? I do see the Final Delimiter String options - but while that is used to flag the end of the record, that does not seem to allow DS to ignore l...

Ah, yes, I see I had a typo in my InfoType field. Thanks - it now works as expected. OUTPUT = DSGetLinkInfo(DSJ.ME,"tran1","outlink",DSJ.LINKROWCOUNT) This is probably a boneheaded question, but are EventType and InfoType really that synonymous? I completely agree I should have m...

Hi; In a server job I'm trying to simply grab a link row count, and write that to the log file. I have an AfterJob routine, which contains the following: $INCLUDE DSINCLUDE JOBCONTROL.H $INCLUDE DSINCLUDE DSJ_XFUNCS.H ErrorCode = 0 OUTPUT = DSGetLinkInfo(DSJ.ME,"tran1","outlink",...

Thanks all. Using the "||" concatenation did the trick. Previously I was trying the '%':KEYFIELD syntax, attempting to have DS resolve the combined string. Which, as I mentioned, resolved to '%'Value instead of '%Value'. I feel like a wee bit of a chowder-head that I didn't think to try ha...

I'm going buggy looking through Oracle-related postings, and so far haven't seen this issue addressed. Basically, I'm creating user-defined SQL in an Oracle Enterprise stage. I want to use the LIKE constraint in my SQL with a variable, but I can't get it to work. As in: WHERE COL1 LIKE '%ORCHESTRATE...

Greetings. I've searched the forums for most of the day and looked around, and didn't see this addressed. So I thought I'd bite the bullet and post this question. As a bit of back story, I've been using older versions of DS for a good number of years, and only recently came on board to a company tha...