Search found 29 matches
- Wed Feb 11, 2009 7:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sqlcode - 1480
- Replies: 7
- Views: 8961
Hello, We changed that also and still we are getting the same problem. It works only when we use completely hard coded values for the update columns including the where clause. But when we pass the values from transformer stage into the Oracle stage, it is not working. All we do is update two varcha...
- Wed Feb 11, 2009 9:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sqlcode - 1480
- Replies: 7
- Views: 8961
- Wed Feb 11, 2009 7:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sqlcode - 1480
- Replies: 7
- Views: 8961
sqlcode - 1480
Hi All, We are using DS EE 7.5. We have a parallel job where we are just doing an update on a varachar column. We are getting sqlcode -1480. Even though it has a not null value, still we are getting the same. Also I checked my environment variable APT_STRING_PAD_CHAR which is having 0x00. We used an...
- Mon Jan 28, 2008 8:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error while running Dsjobs
- Replies: 12
- Views: 5788
- Mon Jan 28, 2008 1:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error while running Dsjobs
- Replies: 12
- Views: 5788
- Mon Jan 28, 2008 12:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error while running Dsjobs
- Replies: 12
- Views: 5788
- Thu Jan 24, 2008 4:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error while running Dsjobs
- Replies: 12
- Views: 5788
- Wed Jan 23, 2008 3:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error while running Dsjobs
- Replies: 12
- Views: 5788
Hi, Due to this problem, is there any chance that we may not be able to export the jobs also ? We are getting this message : Error calling subroutine: *DataStage*DSR_SELECT (Action=2); check DataStage is set up correctly in project castle (The connection is broken (81002)) We wanted to export the jo...
- Tue Jan 22, 2008 1:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error while running Dsjobs
- Replies: 12
- Views: 5788
- Mon Aug 20, 2007 7:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Issue while trying to use ODBC stage...
- Replies: 3
- Views: 1857
Issue while trying to use ODBC stage...
Hi, We have DS installed on Unix(Solaris).I created a dsn (non-wired protocol) for oracle in DataStage Server 7.5.1a. I have done the configuration settings in .odbc.ini and uvodbc.config. Also made the changes required in the uvodbc.config Projects/<projectname>. I tested the connections and was ab...
- Mon Jul 23, 2007 5:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using MS-Access db as source
- Replies: 2
- Views: 1807
Using MS-Access db as source
Hi
We have DS7.5.1 installed on Unix. How can we use MS-Access as source?
Is there any option out to extract data directly from MS-Access db? Please suggest.
Regards
Ramesh
We have DS7.5.1 installed on Unix. How can we use MS-Access as source?
Is there any option out to extract data directly from MS-Access db? Please suggest.
Regards
Ramesh
- Fri Jun 08, 2007 7:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: to read a paragraph data(clob datatype)
- Replies: 4
- Views: 2328
- Thu Jun 07, 2007 11:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: to read a paragraph data(clob datatype)
- Replies: 4
- Views: 2328
to read a paragraph data(clob datatype)
Hi, We have a requirement to read a text data which is running in paragraphs with newlines in between. The source is a sequential file. We have defined LongVarChar in DataStage to read this column as the target database will have CLOB datatype for this column. But still when I tried to view the reco...
- Wed May 23, 2007 6:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error while trying to load timestamp data into oracle
- Replies: 8
- Views: 2607
- Wed May 23, 2007 2:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error while trying to load timestamp data into oracle
- Replies: 8
- Views: 2607
Error while trying to load timestamp data into oracle
Hi, I have a flat file input with a datetime column. The input data will have the format mm/dd/yyyy hh:mm:ss. The target is oracle database. When I tried to load data, I am getting the error Datetime field overflow. I have chosen timestamp as the datatype in DataStage and date in the target Odbc sta...