DSXchange

i am calling the sequencer through unix script i am getting the error [b]Job sjxxxx cannot be multiply invoked[/b] while invoking the sequencer.can anybody tell me the solution.
Thanks in advance

How can i run a SQL store procedure which creates a text file. I tried with ODBC stage giving dummy output links to the transformer and to a text file, but the job aborts because it is not giving any result set gives an error message like this " DSD.BCIOpenR call to SQLNumResultCols failed. SQL...

Hi kDuke,
Thanks for the reply.Actually i have to use DSGetLinkInfo function in the transformer so Can you tell me how to use that function.
Thanks,
rgandra

[quote="ArndW"]rgandra, the DSGetJobInfo is not an array but is a function and needs to be declared before you use it. What you need to insert into your source code is the statement [code]$INCLUDE DSINCLUDE JOBCONTROL.H[/code] which defines that function call.[/quote] Hi ArndW, Thanks for ...

I have parllel job on DataStage7.5 in that I tried to use DSGetLinkInfo in my parllel job but it is giving syntax error AS DSGetLinkInfo variable not defined.I know usage of DSGetLinkInfo in server job.Can anyone help me how to use DSGetLinkInfo in parllel?

Hi Aditya,

Go to job properties and select EXECSH from the before job subroutine drop down. specify any input parameters in the input value field.

Thanks
sandeep

Hi folks, I am trying to install DataStage 7.5 on sun solaris. I am getting the follwing error: /export/home/alandau/install.sh: //solaris/server.: cannot open ERROR: cannot unpack libdslic.so I went thru previous Posts but that didn't solve the problem. Any help is appreciated. -sandeep

Narendra,

Check the if and else staments in the transformer. I think, somewhere you are missing else clause.

Check the first tranformer in your job as mentioned in the error. If you are not using if else clauses let me know what ru doing.


-sandeep

Hi, The file generated in DATASTAGE is going to be used in MAINFRAME COBOL program. So I need to convert the ASCII file into EBCDIC from. I did the following steps to covert ASCII to EBCDIC but the numeric fileds are showing in the text fromat. Please let me know are there any other methods availabl...

hi

You can use the routines like gennextkey to generate surrogate keys.

-sandeep

Hi

Can you give some more description about your problem? As what exactly you want to do with that files?


sandeep

Hi

If i understand your problem correctly here is the solution.

1)use sql server as source.
2)use as400 table as look up.
3) in the transformer use a constraint i.e ISNULL(COLUMN)=@TRUE.
4) send the output to target as400.

Any questions let me know
sandeep

Thanks Ray

I really appreciate your time.

sandeep

thanks ray for your quick response. I was doing the way you have suggested for most of my jobs. I have used the command only for the jobs that locked in process. I mean when i see the message 'cannot get exclusive to the job'. Could you please tell me one more thing, as my over30 size for ds_jobobje...

Hi folks, Do we need to delete RT_STATUS,LOG,BP,CONFIG files before deleting a job?. Or can we delete directly from the admin command window using DELETE FROM DS_JOBS WHERE NAME 'jobname'? I usually prefer the later command. I didn't face any problem so far.But still, after deleting the job you can ...