DSXchange

kris007 wrote:I'll have to dig it out from my notes. May be later in the evening today.

thanks Kris.

You cannot do it from DRS stage. That is my understanding. Last time I had to execute a 3000line sql code, I had to write a routine to connect to oracle and execute the sqlscript. I can paste that routine here if you are interested in it. Could you please paste that routine here for me, Kris. Thank...

There is a limit of 700 lines for user-defined sql in OCI stage and I think it applies to all other DB stages though not sure since never tried such a big user-defined sql. If your code exceeds that limit then running a sql script is another choice. thanks for info,Kris. Could you please explain a ...

For using User Defined SQL file you will have to provide its path. Also, whats the complexity of your SQL and how many lines of code is it? thank you Meena & thumsup9 for your replies. My sql is not very complex...but it has got pretty large no. of line.I am unable to paste complete/(all lines)...

Hi all: I am trying to read source data from Oracle table using DRS.Iam unable to put my complete USER defined SQL in 'SQL' tab. I think there some limitations on size/no of lines that we can put over there. The next option I know is..User Defined SQL file. Can some one help me on how to call a &quo...

chulett wrote:Or just stick with an 'Unconditional' trigger.

Thank you all.
Just want to make sure I understand it correctly.
Routine Activity fails unless untill the Ans = 0. When ever we use routine activity in Sequence jobs we use 'Unconditional' trigger.

sud wrote:You are computing the previous year in the routine. You can do the same in a set user variables stage(instead of the routine stage) by defining a new variable and calling your routine there. That way subsequent jobs wil run.

Pardon my ignorance, could you please elaborate it?

Kris, thanks a lot for the quick reply. My design is as below... 1) Get the Previous Year on your SYSDATE ( it returns 2005 now) 2) Pass this value ( 2005 in this case) to all my next Job Activities. 3) my undetlying jobs will use this value and pulls the data relevent to that particular year ( 2005...

greetings. below is my routine code which gives me previous year based on SYSDATE. When Iam testing the Routine its working fine. But when I use it in a Sequence job with expression = "OK (Conditional)", the jobs after this Routine Activity are NOT being called. If I change the Routine Act...

Our problem was with the Unix OS level limitations. We cannot create more than 32767 directories with in a directory. After this , the link limit for the unix will be consumed and it will not allow you to create any directory. as Type 30 hash file is a directory, it did not allow us to create any d...

We are having both the server and prallel extender in the same box. When the parallel jobs are running the server jobs are getting the following message and abortings!!!! Unable to allocate Type 30 descriptor, table is full. DataStage Job 3096 Phantom 24343 DataStage Phantom Finished Do any of you ...

Hi, To fill my needs more precisely I wrote my own version of the SwitchEBCDICSign. Function SwitchEBCDICSign(Montant) LMontant=Trim(Montant) Longeur=len(LMontant) Lien=LMontant[1,Longeur-1] Car=SEQ(Right(LMontant,1)) if num(LMontant) then Ans=LMontant else * Call DSLogInfo("Montant ":LMo...

ray.wurlod wrote:It's probably easier to create a CFD manually (in Notepad perhaps), import that, and proceed with using a CFF stage.

thanks Ray.

I am new to cobol file. Could you please guide me in creating CFD? or jus through some light on how CFD looks like...

thanks in advance,

Your EBCDIC is allready transfered to ASCII so use this function: FUNCTION SwitchEBCDICSign(Arg1) Laenge=len(Arg1) Links=Arg1[1,Laenge-1] Hyro=SEQ(Arg1[1]) BEGIN CASE CASE Hyro >= 65 AND Hyro <= 73; Ans=(Links:Hyro-64)+0 CASE Hyro >= 74 AND Hyro <= 82; Ans=(Links:Hyro-73)*-1 CASE Hyro=249 ; Ans=(Li...

Hi all, In my Cobol source file, I have field as S(5)V99.The values are like 000770{ 001690D 000845B 011250{ I tried to use DataTypePicS9 / DataTypePicComp3V99 / DataTypeEbcdicPic9V99 But I could not convert and load it into my target DB (Oracle) Please some though some light ... thanks in advance,