Search found 1213 matches
- Mon Nov 08, 2010 4:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Routine to connect SQL Server
- Replies: 11
- Views: 3894
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. > ...
- Sun Nov 07, 2010 5:25 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Routine to connect SQL Server
- Replies: 11
- Views: 3894
- Sun Nov 07, 2010 4:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Routine to connect SQL Server
- Replies: 11
- Views: 3894
- Sun Nov 07, 2010 4:24 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Routine to connect SQL Server
- Replies: 11
- Views: 3894
Still getting error
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 = &...
- Sun Nov 07, 2010 6:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Routine to connect SQL Server
- Replies: 11
- Views: 3894
Server Routine to connect SQL Server
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...
- Fri Mar 06, 2009 7:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error compiling parallel transformer
- Replies: 10
- Views: 5231
Re: Cleaned
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
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
- Fri Mar 06, 2009 7:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error compiling parallel transformer
- Replies: 10
- Views: 5231
Re: Cleaned
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 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
- Mon Feb 09, 2009 10:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Numeric Loop Value
- Replies: 7
- Views: 4247
Re: Numeric Loop Value
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...
- Mon Feb 09, 2009 8:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error compiling parallel transformer
- Replies: 10
- Views: 5231
Cleaned
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
1. I deleted (even after uninstalled can find few folders) from system (folders)
2. I cleaned from registry by searching "IBM".
Thanks
Ram
- Mon Feb 09, 2009 5:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error compiling parallel transformer
- Replies: 10
- Views: 5231
Same Error
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
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
- Sun Feb 08, 2009 4:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error compiling parallel transformer
- Replies: 10
- Views: 5231
Found issues
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...
- Sun Feb 08, 2009 1:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error compiling parallel transformer
- Replies: 10
- Views: 5231
Correct Version
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...
- Sat Feb 07, 2009 8:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error compiling parallel transformer
- Replies: 10
- Views: 5231
Error compiling parallel transformer
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...
- Sat Feb 07, 2009 4:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No DataStage credentials were found
- Replies: 7
- Views: 8075
Re: No DataStage credentials were found
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 ...
- Sat Feb 07, 2009 6:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No DataStage credentials were found
- Replies: 7
- Views: 8075
No DataStage credentials were found
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 ...