DSXchange

Faced this problem earlier and we rebuilt indices and it started working fine. Try building reindex and post it how it goes. Regards Saravanan Hi Saravanan Thanks for your reply. But, I dint quite understand rebuilding of indices. Could you please explain it further. Are you telling about rebuildin...

I am getting the following error while running a job. Actually the job postal_loc_pickdel_20 is triggered from a Job Sequence SEQ_postal_loc_pickdel . While I run the sequence alone it runs fine. But while I try to trigger the sequenec SEQ_postal_loc_pickdel from another sequence this problem occurs...

Hi I agree that 300000 is not a big number. But this is the smallest number of the BIGGER table group. The bulkiest is around 1 million. And it is much bigger compared to the number of rows to be processed; equals 50-100 on average. I have tried with all the combination of formats for the DATE colum...

Hi I have been using a look up through ODBC as follows. Input----->TX-----Target(ODBC) ^ | ODBC (tab1) Key columns for tab1 are K1 (Decimal(13,0)) K2 (DATE). For smaller tables this is working fine. But for tables with large volume of data (more than 2-3 lakhs) some time look up is returning values ...

ray.wurlod wrote:You could pass the result back through any of the @USER0 through @USER4 system variables, and return 0 through Ans.

Hi Ray

Can You put some more light on these variable. It will be a great help for me.

Regards
Rubu

Hi I am writing to a Seq File from After Job routine using WRITESEQ. By nature this command start writing from the starting of the file pointer. Since OpenSeq opens a file with the pointer at the begining it always overwrite the existing data. My requirement is, I want to add new rows to the existin...

Yes Andrw

I was trying to put a constraint for a link using link variable of the same link.

E.g. The constraint for the link DSlink120 was set as DSLink120.DBMSCODE=0. Since The same link was referred inside its constraint it was giving above error.

Thanks Andrw

I could solved that using the steps you suggested.

rubu

Hi All Everytime I runa Job foloowing error pops up just before the jobs finishes satying.... DataStage Job 112 Phantom 27637 Program "JOB.869489309.DT.1363449358.TRANS7": Line 228, Variable previously undefined. Zero length string used. DataStage Phantom Finished It does not have a transf...

Thanks Andrw yes, it will give me the values from the Seq File. Now I want Set Parameters in my job as those values from the Seq file. I added following code in Job Control to asign NAME="rubu". But this routine is giving both the warning messages included in... saying "BAD HANDLE&quo...

Hi

I want to read a text file and Pass a couple of values to 2 JOB PARAMETERS. Can it be achieved in job control routine?

Is it possible to asign values to parameters in Job Control?

Regards
Palasjyoti

Thanks All of you.
I actually did not include the jobcontrol.h file...

Hi While Compiling a Transform Rouitne I am recieving following error. Compiling: Source = 'DSU_BP/DSU.WriteSequence', Object = 'DSU_BP.O/DSU.WriteSequence' *?* 0012 Count=DSGetLinkInfo(JobHandle,LStageName,LLinkName,DSJ.LINKROWCOUNT) .......................... ^ ',' unexpected, Was expecting: '!', ...

Hi I put the following script inside the JOB control of a job. I want it to stop when the parameter RE_PLAY='N'. IF RE_PLAY="N" THEN ErrCode = DSStopJob(DSJ.ME) IF ErrCode=0 THEN Call DSLogInfo("Job stopped because input file empty", "Job control") END ELSE Call DSLogWa...

Hi All

while trying to open a project I am getting the following error.

Its says:

Cannot open executable job file RT_CONFIG118.

But from another machine I can open the same project without any problem.
Any idea what this RT_CONFIG file stores?

Regards
Palasjyoti