Thanks chulett & ArndW
I have tried it as server job .it works.
.
Search found 12 matches
- Fri Mar 05, 2010 9:12 am
- Forum: General
- Topic: how to create a lookup link in datastage
- Replies: 6
- Views: 11986
- Fri Mar 05, 2010 8:14 am
- Forum: General
- Topic: how to create a lookup link in datastage
- Replies: 6
- Views: 11986
Hi Arnd , Thanks for the reply . I am following this url for my job :- http://www.ibm.com/developerworks/data/library/techarticle/dm-0703xiong/#step1.1 In this tutorial If you look at fig:10 Job Diagram There are two links DSLINK3 is a stream link for the transformer DSLink4 is a lookup link for the...
- Fri Mar 05, 2010 5:45 am
- Forum: General
- Topic: how to create a lookup link in datastage
- Replies: 6
- Views: 11986
how to create a lookup link in datastage
I have two tables customer & contact .customer is the primary table & contact is the secondary table.I am joining the tables and passing the output file . While doing the link process between the databases and sequential file . it throws me an error 40813 .The destination stage cannot suppor...
- Thu Oct 16, 2008 3:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSN Problemwith DB2 Database
- Replies: 1
- Views: 2214
DSN Problemwith DB2 Database
While Running the map i am getting the Following error at the intial stage . [IIS-CONN-ODBC-000004] ODBC function "SQLConnect" reported: SQLSTATE = IM003: Native Error Code = 160: Msg = Specified driver could not be loaded due to system error 5 (IBM DB2 ODBC DRIVER - DB2COPY). (CC_OdbcConn...
- Fri Sep 26, 2008 7:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: import metadata from db2 to tabledefinitions
- Replies: 4
- Views: 1987
import metadata from db2 to tabledefinitions
While importing the data from table to table definitions using odbc from import metadata . I have been facing the following error DSR.MetaGeta(GET.COLUMNS)(SQLCOLUMNS(",'USER1','EMPLOYEE',") BCI Error: SQLSTATE=38553,CODE=-443,[DataStage][Sql Client ][ODBC][IBM][CLIDriver][DB2/NT]SQL0443N ...
- Tue Aug 05, 2008 12:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Download Link
- Replies: 1
- Views: 1351
Download Link
Where can i get the trial downloads from Datastage 8.x
- Tue Feb 05, 2008 11:17 am
- Forum: General
- Topic: importing tables from odbc
- Replies: 3
- Views: 2800
importing tables from odbc
While trying to retrive table data from import using odbc definitions i am getting the following error showing as Datastage repository interface DSR.MetaGeta:Cannot read result file DS_METATEMP record METAGETA-2600 from GetMetaData this is only with db2 database tables rest all the databases (oracle...
- Tue Dec 11, 2007 2:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using SQL queries in job parameters
- Replies: 3
- Views: 2234
- Thu Sep 06, 2007 11:37 am
- Forum: General
- Topic: Not able to view the jobs list under the job category
- Replies: 4
- Views: 2273
- Thu Sep 06, 2007 11:20 am
- Forum: General
- Topic: Not able to view the jobs list under the job category
- Replies: 4
- Views: 2273
Not able to view the jobs list under the job category
Hi All I was not able to view the Jobs list under the Jobs category in Datastage Designer window.Even when a new category or job is created i am not able to see them under jobs category.Is there any option to hide the jobs list and review them?I need help regarding this issue. Thanks in Advance priya
- Fri May 11, 2007 8:17 am
- Forum: General
- Topic: differences b/w v7.51A and v7.5x2 of Ascential Datastage
- Replies: 1
- Views: 1658
differences b/w v7.51A and v7.5x2 of Ascential Datastage
Hi
could any one help me out in knowing the differences between Version 7.51A and Version 7.5x2 of Ascential Datastage.
Thanku
could any one help me out in knowing the differences between Version 7.51A and Version 7.5x2 of Ascential Datastage.
Thanku
- Fri Feb 16, 2007 3:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer stage is not working in parallel jobs
- Replies: 2
- Views: 1063
Transformer stage is not working in parallel jobs
We are using Ascential Datastage 7X software which is installed on AIX server.In the client (Windows) the transformer stage is not working i.e it is showing error in the compilation stage. If some properties like enable remote execution of parallel jobs etc. are set in the administrator then it is s...