DSXchange

Hi
I don't think doing Unchecking the box "Log warnings for stages that dint finish ok" in the sequence properties is a correct thing.
We had to handle this in routine activity.

Regards
Sasi

Added point to my question
the value for status variable is 1 and i understood that the sqlconnect is returning SQL_SUCCESS_WITH_INFO.

How to handle this as i am unable to insert or update a table.

Thanks in Advance
Sasi

Hi I had tried to implement the code and i found new issues now. As in my code i had copule of scenario's Scenario 1 : $INCLUDE DSINCLUDE JOBCONTROL.H $INCLUDE UNIVERSE.INCLUDE ODBC.H * Database Environment Settings henv = SQL.NULL.HENV hConn = SQL.NULL.HDBC hStmt = SQL.NULL.HSTMT **Ans=0 ** Connect...

Hi "That's not how you call SQLError(). The third argument must be a valid statement handle." I can understand that i am doing some mistake with the statement what you have given , can you please guide me how to resolve this . What is wrong with thrid argument . is there any alternative me...

Hi Thanks for your response I am able to check that whether the database connection is working or not and the connection is establised . Now i am facing problem with the update statement Like SQLStmt = "update copy.sampl set Idvalue=3000 where ID=1;" If Right(TrimB(SQLStmt),1) <> ";&q...

Hi I can understand the experts feeling that its a stupid requirement but the situation is like that i had to provide a solution in such a manner. Thanks for your valuable advises and thoughts. With the inputs available in the forum I am able to write up the routine but it is compiled with zero erro...

Hi
I had reframed my statement. Can any one clarify the issue

Regards
Sasi

Hi
Can anyone share some idea on this as i tried to find relevent information in the forum using the keyword BCI but i didn't able to find the relevent post related to my issue.

Kindly suggest

Thanks
Sasi

Hi
Is it possible to update a database table from a basic transform routine.

Thanks in advance

sasi

Its a Basic Transform Routine in Parallel jobs

Hi Can some one help me on how to write data to a table from a basic routine. Its a kind of requirement where in i had to update a table from a routine. How to connect to a database from a routine. How to write the update statement in a routine means can i directly use the update statement or is the...

Ooooops...Sorry ....

Dilip,

Try to install Visual Studio 2003 c++ compiler first before installing DataStage on u r machine for DataStage Version 7.5.x2 to work.

Cheers

Hi Ray, Thanks for the Response. When i m using the above given command , i m getting error as An expression term lacks a required parameter. Code i m executing is OsType = 'UNIX' Move = "cd " : SourceDir : " && find . -exec mv {} " : TargetDir : "\;" Call DSExe...

Hi, I want to move huge number of files from one directory to another directory. For that i wrote a routine, and when i test this routine it is just moving all the DataStage Repository files to the Target directory instead of moving only files from source path . OsType = 'UNIX' Move = 'ls | xargs -t...