DSXchange

Thank you chulett..You solution solve my probelm. Appreaciate your help.

Me thinks the problem lies here. :wink: For ParamNum = 1 to ParamCount Param(ParamNum,1) = Field(Field(Params,'|',ParamNum),'=',1) Param(ParamNum,2) = Field(Field(Params,'|',ParamNum),'=',2) Next ParamNum You've specifically just pulled everything before the second equal sign and left the rest behi...

Partheev,

Yes I agree with you..if you pass SQL query manulay as paraemter value then it works for me. But my requirement is to pass the parameter at run time and it does not work...

Thanks,

I tried the same but it result as follows:

select * from emp where empname

you solution will be applicable handling the single quotes.

$INCLUDE DSINCLUDE JOBCONTROL.H Equate RoutineName To 'RunJob' Equate RunJobName to Arg1 Equate Params To Arg2 Equate RowLimit To Arg3 Equate WarnLimit To Arg4 Dim Param(100,2) ; * Limited to max of 100 parameters Deffun DSRMessage(A1, A2, A3) Calling "*DataStage*DSR_MESSAGE" Deffun DSRTim...

Yes I tried putting sigle quotes as well but it truncate from equal sign. Well I have 2 jobs one is master(Server Job) and one is detail(Parrellel Job). Master job invoke detail job by server routine and server routine need SQL query as paramter. And SQL query is coming from control table.That's the...

Yes tried but it still truncate the from eqal sign.

Yes we can reaplce equal sign by IN clause ..but that is last option I was thinking to chnage the control table query.

Thanks for your input...

Hello All, I am trying to pass the Oracle SQL query as paramter in DS job and when I run the job datastage simply trim the string where it find the first equal sign inside the query. Could anyone of you tell how to handle the equal sign if paramter value itlself containing equal sign. For Example : ...

Thank you for reply..

but how about on Windows XP Professional 64 bit..?

Thanks,
Satish

Thanks a lot for replying..

but Can we install the same on Windows 7 Professional or Ultimate Edition?

Thanks,
Satish

Hi All, I am trying to install datastage 8.1 into Windows 7 Home Edition (64 bit). And when run setup , the setup wizard disable the Services and Engine component from the setup. Is it because of incompatibility with 64 bit windows operating system. Could please anyone of you help how to install dat...

Hello Everyone, I am trying the following calculation from last one week and was not through to add months ,qaarters and year into input date based on period condition. here is requirement details mentioned below: Business Rule: ============ IF Period_Flag = "M", Increment Input_Date by 1 ...

[quote="ray.wurlod"]I tested the more recent one that I posted and it works. For arbitrary string lengths. On what basis do you assert otherwise? ...[/quote] Dude I did not use Basic Transfromer stage and I am using Prallel Transfer Stage and it does show invalid derivation error. Hope thi...

[quote="ray.wurlod"]Using a BASIC Transformer stage: [code]Convert(@TM, ".", Fmt(InLink.TheString, "1L"))[/code] (I have tested this one and it does work.) ...[/quote] Hello All, Unfortunatly none of the solution works fine. hence I used finaly unix script to acheive th...

ray.wurlod wrote:I don't have the chance to try this, but you might try

Code: Select all

Convert("", ".", InLink.TheString)

No promises. ...

Hi Ray,

Thanks for your reply. This solution sounds good to me as well but I will confirm you tomorrow on this as soon as I reach to office.

Satish