Search found 12 matches

by phanipriya
Fri Mar 05, 2010 9:12 am
Forum: General
Topic: how to create a lookup link in datastage
Replies: 6
Views: 11986

Thanks chulett & ArndW

I have tried it as server job .it works.

.
by phanipriya
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...
by phanipriya
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...
by phanipriya
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...
by phanipriya
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 ...
by phanipriya
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
by phanipriya
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...
by phanipriya
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

Hi

SQL Queries can be passed as values to the job parameters directly and even the other job parameters can be passed as values to the conditions in the query using #<job-parameter name>#
by phanipriya
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

Are you able to view the jobs in the tree when you do a "File/Open" (to open existing jobs) or when you create a new job and do a "File/Save"? Hi I am not able to view it when a "File/Open" is done or when a new job is created and saved.Just i am able to see Jobs and u...
by phanipriya
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
by phanipriya
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
by phanipriya
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...