DSXchange

Since you said "with the same login id and works from another machine", I will suggest the best way to debug this problem is to put the trace on the ODBC. Good luck. You want me do on my Database side..If it is in Datastage how will you the trace of odbc..Is there any way of checking the ...

Hi, I have some weired thing that is going on..I created a new odbc for sqlsever in the .odbc.ini and follwoing thing on my project folder but it is not working..the same connection from development is working there is no firewall or any thing but it gives me that login failed..but the same same log...

Stop. Step back. Ignore DataStage for the moment. Write out (in English) a complete specification of what is supposed to happen, including one or two examples. Then post that here. ... Ok here is what it is... We have a tableA. where we have strings like 1000 10001 1004.. There is another tableb wh...

Time to involve your official Support provider, it seems. Yes i did Criag now..Let see...I will post the solution once they solve it.... guys, I contacted.. the support... I solved that by.... We should not give thw like in the SQL rather we should give in the Transformer derivation for the refrenc...

chulett wrote:Time to involve your official Support provider, it seems.

Yes i did Criag now..Let see...I will post the solution once they solve it....

ray.wurlod wrote:I don't really have much else to offer. What stage type are you using on the reference link? If it's OCI you might try :1 instead of ? for the parameter marker. ...

I tried with db2API,ODBC,DRDBMS,UV......none of them works ray....

Thanks,

sorry Ray to bother you more..This problem is just annyoing me much.... SELECT columns FROM TableB WHERE keycolumn LIKE '?%'------Not works even though there is a matched column it just gives me 0 records but i did a work around with left function in the constraint part; SELECT columns FROM TableB W...

Stop. Step back. Ignore DataStage for the moment. Write out (in English) a complete specification of what is supposed to happen, including one or two examples. Then post that here. ... Ok here is what it is... We have a tableA. where we have strings like 1000 10001 1004.. There is another tableb wh...

You give the SQL statement in the stage that is servicing your reference link. As for "in detail", perhaps purchasing premium membership would permit you to read my reply in its entirety. There no error but it retrives 0 records but we do have matching records though..what can we do about...

ray.wurlod wrote:You give the SQL statement in the stage that is servicing your reference link.

As for "in detail", perhaps purchasing premium membership would permit you to read my reply in its entirety.

Ray,

I do have that with my friend..Thanks for your response.....

I read the problem as the more general one where, if the second column is 1 you need a lookup WHERE KEYVALUE LIKE '?%' but, if the second column is 2 you need a lookup WHERE KEYVALUE LIKE '% ... sorry ray for the late replay..I tried your way but where do i give the like statement..But i can't able...

Two Transformer stages, with the second lookup being conditional upon success of the first (a constraint in the first Transformer stage). Use other output links if needed to capture rows that fail ei ... Ray, can i know what constrint i should use here..also does codntion you are suggesting here is...

Hi I have a Logic questions..It's basicall a table match up but There are two options in the table 1 to look in to table 2... Table has following examples of vaules MatchString Type 10 1 104 1 14578 2 Where 1 represent starts with that string we should macth a string from another table..... where 2 ...

The exit status of dsjob is (can be) affected by its arguments. For example the -jobstatus argument causes the job's status (0 = running, 1 = finished, etc.) to be the exit status of th ... Ray, The thing i want to acheive here is that..i have to run the job, once it finished i have to get the jobi...

Hi, I have a issue here when i run the job from command prompt..it's basically a shell script where i create log for every schedule run.when i give the dsjob -run command..it says status code 0..after that i give the next command to dsjob -run as dsjob -jobinfo..what it does is after a while it just...