DSXchange

Hi Ray I dont know what mistake i am doing, but i will keep on try to make it work. Meanwhlie if anyone find the way, that will be real help. But when i tried isql i am getting the below error. TEST #1 ******* DSLogWarn called from : GetID Message to be logged is... > Error executing SQL command. > ...

Hi chulett I corrected the errors. This time after it executed i didnt get any return value at all (hope it hangs). SQL = "sqlcmd -S DBNAME -U UNAME-P PWD" : char(010) Command = SQL : char(010) Command := 'use Development' : char(010) Command := 'select max(id) from ID_Table' : char(010) I...

Dear chulett You are right. After i did it, i got the error details. I am trying to correct it. Meanwhile if you can figureout the error pls do help me. - Thanks Arg1 = sqlcmd -S DBNAME -U UNAME -P PWD Test failed. Program "DSU.GetID": Line 7, Variable "Commnad" previously undefi...

Hi Ray Thanks for your reply. Yes i did that "Sql", but still getting error. I am getting the user defined error return code of -98. Please guide me, what mistake i did in this. RoutineName = 'GetID' Debug = 0 * Passing this value'sqlcmd OR isql -S DBNAME -U UNAME -P PASSWD' to Sql SQL = &...

I am trying to connect SQL Server using server routine. See the below peace of code. Sql = "will have the connection details for sql server" Debug = 0 SQL = Sql Command = SQL Command := 'select id from Id_table' and then the output will be captures eventually. But it is not connecting to D...

Hi

I reinstalled the OS, C++ and DS and now it is working fine.

Steps.

Installed Server 2003.
Installed Visual Studio
Configure C++
Installed SDK
Installed DS
Using Web console given necessary permissions to the user.

Result:

Now DS8 is working fine.

Thanks for the guidance.

Regards
Ram

Hi

I reinstalled the OS, C++ and DS and now it is working fine.

Steps.

Installed Server 2003.
Installed Visual Studio
Configure C++
Installed SDK
Installed DS
Using Webconsole given necessary permissions to the user.

Result:

Now DS8 is working fine.

Thanks for the guidence.

Regards
Ram

I have a numeric loop. Loop end value is based on the number value in the .txt file I have a execute command stage to read the value from the .txt file. Execute command stage is having line this - cat test.txt e.g. if this file is having the number 10, loop should be executed for 10 times. in the l...

Yes Ray

1. I deleted (even after uninstalled can find few folders) from system (folders)
2. I cleaned from registry by searching "IBM".

Thanks
Ram

Hi Ray

I uninstalled again and reinstalled as follows

1. VC++ and then tool kit.
2. DS Server

Even after i am getting the same error.

Please guide me in this.

Thanks
Ram

Hi Ray That may be the cause!! I installed Visual Studio 2005. While i was installing SQL server found some issues, but not with VC++. I thought of it will be ok and then i installed Datastage. I will clean up again and try to install it, and post the status. Thanks for the comment. Thanks & Reg...

Hi Thanks for the comment. I installed the proper version and i am aware this is related to configure issue. But i am not sure how to do it. If you have any idea please share with me. Thanks Ram Looks like you have not installed the VC++ compiler or installed a wrong version or not configured the ne...

Hi I installed Datastage 8.0 in windows 2003 server. My server jobs are running good. But none of my paralles jobs are not running. Job: Rowgenerator --> TFM --> Peek Compilation Error: Cannot open file compile.tmp Next Job: Sequential File --> Sequential File No Compilation Error. But getting run t...

Thanks to Craig Hulett and Ray Need to login into ibm information server to resolve this issue. I followed as you said and it is working fine. Thanks Ram Hi I installed the Datastage 8.0 in windows 2003 server. Installation went smoothly. But when i tried to open the Designer in windows 2003 server ...

Hi I installed the Datastage 8.0 in windows 2003 server. Installation went smoothly. But when i tried to open the Designer in windows 2003 server i am getting the below error. "No DataStage credentials were found on the Domain for the user ('xxx') and Datastage server ('yyyyyyy'). I am getting ...