DSXchange

I added an environment variable -m32 for APT_COMPILER, it removed the error.

but i got a different error this time.

Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program DSP.Open at address 574.

Any ideas what it could be....!

Any idea what happened to the solution?

Can any body please confirm,

Do i have to install the iseries access software on the Datastage Server(Unix) but the name says "iseries access for windows" ,
Just the ODBC way would do to connect to iseries access on datastage.

Hi Ray, I dont see any answer, but that doesn't mean that the person who has asked this question has not got the answer, may be he might have figured it out and forgot to update in the forum. We should always see both sides of the story. simply being sarcastic doesn't help this forum or any one for ...

Did you get answer to this query?

what is the right port number u gave? drver?

may be you can use a uv command to LIST all the job names in the project directry, and write it to a file and then search in that file....this shd give you the syntax.

I had to undo all the changes w.r.t ODBC settings in the config files like dsenv
.odbc.ini
uvodbc.config , not sure why it was running......
Can anybody guesss whats the problem...!

Thanks vinoth for your suggestion.

Folks can somebody throw some light on this issue.?

Even i tried with the Db stages whichever i have got....they all perform view data....when i view it...but when i run nothing happens no signs of running or warning..!

FYI i was setting up a new ODBC connection like changing odc.ini and uvodbc.config files....thats all... but i am not able to run simple job which source and target as sequential file...! it has nothing to do with odbc or database or anything...! Any hints would be really help ful at this point of t...

Also what you could do is to Use Stage variables and compare with the previous ID and make sure the ID is sorted.

Thanks all .....got it by using escape character \

example

Q >> \'A\'

Hi All, I am using a simple Select statement and i am trying to parameterise the Where clause on one column which can be an integer or varchar or char. i am getting the problem when i run the job. example select col1,col2 from T #p# where p >> where col1= 'A' Note col1 is varchar i can use one more ...

Hi priyadarshikunal

I didnt find this variable in DS GETTOD_ADJ_MONOTONIC,
Are you sure this env variable is going to solve the issue?

i have to remove these warnings....anyways.