Hi Creo
I don't use any parameters and it it pretty straight job with just one routine.The only thing is that it has got 27 columns.Is there any limitation on the number of columns?
Regards
Shiva
Shivakumar
Search found 100 matches
- Tue Jun 03, 2003 10:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Parameter Marker
- Replies: 5
- Views: 3841
- Sat May 31, 2003 5:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Parameter Marker
- Replies: 5
- Views: 3841
Parameter Marker
Hi All When i run a job it gets aborted by flashing the below warnings. Can anyone explain what does it mean. Any help would be greatly appreciated. Regards Shiva SJETL2CLM5..Transformer_1.DSLink4: DSD.BCIPut call to SQLExecute failed. SQLSTATE=IM974, DBMS.CODE=0 [DataStage][SQL Client]Parameter mar...
- Wed May 28, 2003 7:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance
- Replies: 3
- Views: 2366
Performance
Hi All I am new to datastage.I've designed a job which populates a table.It extracts the data from three different tables,90% of the rows come from a particular table.In the transformer stage I perform many substring functions on particular input column which feed the appropriate columns in the targ...
- Sat May 24, 2003 12:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Crash
- Replies: 4
- Views: 1452
- Wed May 21, 2003 5:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dta Formatting
- Replies: 2
- Views: 950
- Wed May 21, 2003 4:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dta Formatting
- Replies: 2
- Views: 950
Dta Formatting
Hi
I have date in 2002-10-25 format and i want to have in MMMYYYY format
I am not able to use the Iconv and Oconv functions as they doesn't have the given format.Any help is appreciated.
[:)]
Shivakumar
I have date in 2002-10-25 format and i want to have in MMMYYYY format
I am not able to use the Iconv and Oconv functions as they doesn't have the given format.Any help is appreciated.
[:)]
Shivakumar
- Wed May 21, 2003 4:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Where can i set Parameter File??
- Replies: 6
- Views: 2290
- Thu May 15, 2003 9:57 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Metadata Retrieval Problem
- Replies: 2
- Views: 1222
- Thu May 15, 2003 4:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Metadata Retrieval Problem
- Replies: 2
- Views: 1222
Metadata Retrieval Problem
Hi When i try to retreive the metadata from DB2 i receive the following message.Please clarify on the same. Any help will be appreciated. Thanks in advance. DSR.MetaGeta(GET.TABLES)(SQLTables): BCI Error: SQLSTATE=42724,CODE=-444,[DataStage][SQL Client][ODBC][IBM][CLI Driver][DB2/6000] SQL0444N Rout...
- Mon May 12, 2003 9:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Crash
- Replies: 4
- Views: 1452
Server Crash
Hello
I have DB2 running on AIX,I've designed a job which loads some 160000 records from DB2 to DB2.This is a simple load without any transformations and I commit every 1000 rows.Once I start the job my server crashes.Can you please help me to figure out the problem
Shivakumar
I have DB2 running on AIX,I've designed a job which loads some 160000 records from DB2 to DB2.This is a simple load without any transformations and I commit every 1000 rows.Once I start the job my server crashes.Can you please help me to figure out the problem
Shivakumar