Search found 26 matches
- Tue Sep 26, 2006 1:21 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to find row that causes error
- Replies: 13
- Views: 8293
I've solved the problem, but I'd still like to get the Reject link working at some point. The last column is inserted as an int, but one of the records has a zero-length string, and after changing the destination column to a varchar, it's going in. So I need to go to the source data, fix the zero-le...
- Tue Sep 26, 2006 10:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to find row that causes error
- Replies: 13
- Views: 8293
i have never worked with SQL Server... in Oracle i manually insert a row using TOAD taking a row from the flat file ... if you can insert one row you can insert pretty much all of them.... if problem persists, you may divide your file into smaller parts and get the problem rows...or get an idea whi...
- Tue Sep 26, 2006 9:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to find row that causes error
- Replies: 13
- Views: 8293
You can use reject file in your job. So if the condition pass you will do the normal process and if any of the codition failed in you transformer than the record will com to reject file. Here you can see the trouble record Perwezakh, I'm already doing this; it's not working - I probably set it up i...
- Tue Sep 26, 2006 9:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to find row that causes error
- Replies: 13
- Views: 8293
Meena,meena wrote:Hi,
Check with the datatypes and the data you are assigning. if you want to catch the rejected records you can use Link varibales/ouput/rejected or DBMS.CODE or SQLCODE.
Thanks, but I don't understand what you mean here -> use Link varibales/ouput/rejected or DBMS.CODE or SQLCODE.
- Tue Sep 26, 2006 9:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to find row that causes error
- Replies: 13
- Views: 8293
Ketfos,
Thanks.. you can see I'm a newbie (still), I just haven't had much time to devote to DataStage.
So I've tried that now, but I can't get the rejects to reject.
Please check out my screenshots here:
http://www.gregmorey.com/jti.html
Thanks.. you can see I'm a newbie (still), I just haven't had much time to devote to DataStage.
So I've tried that now, but I can't get the rejects to reject.
Please check out my screenshots here:
http://www.gregmorey.com/jti.html
- Mon Sep 25, 2006 2:25 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to find row that causes error
- Replies: 13
- Views: 8293
How to find row that causes error
Hi, I've got a job that does a SQL Server insert (ODBC) and am getting the following error: SQLSTATE=22005, DBMS.CODE=0 [DataStage][SQL Client]Non-numeric data was found where numeric required The table has about 40 fields in it. The total number of rows is around 150,000. I'm looking for a simple w...
- Wed Mar 15, 2006 11:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: UniData 6 stage - need info
- Replies: 5
- Views: 2451
- Wed Mar 15, 2006 10:30 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: UniData 6 stage - need info
- Replies: 5
- Views: 2451
The dictionary is what is used. Dictionaries can contain correlatives that point to other files. This is why Universe and Unidata are so complicated. If the dictionaries are not pure A or S types, ... Our dev environment's dictionary has the field listed as an I type, but the production environment...
- Wed Mar 15, 2006 10:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: UniData 6 stage - need info
- Replies: 5
- Views: 2451
UniData 6 stage - need info
Our DataStage ETL jobs were set up a couple of years ago by developers that no longer work here, so one of our big challenges is figuring out what they did and how they did it so we can make changes as necessary. We have 2 UniData 6 database servers, development and production, and we are successful...
- Tue Feb 28, 2006 11:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: error connecting to UniData 6
- Replies: 9
- Views: 5874
After manually changing a couple of files to match the ones on production, we were able to get to the table/file, but got a new error: ....job_in: ds_ucigetnext() - SQLBindMvCol: Failed with SQLSTATE S1000 - Native error 0, [IBM][SQL Client][UNIDATA]Unidata lower level function error with fetch Also...
- Mon Feb 27, 2006 11:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: error connecting to UniData 6
- Replies: 9
- Views: 5874
I might have the solution now. There is a readme.txt file in the \Ascential\Datastage\ folder that has a bit about the new (as of 7.1) UniData 6 stage. It states that a script, MIGRATE.SQL, must be run on an account to make it a UniData 6 account. Another program, Privilege.B, must be run to make t...
- Mon Feb 27, 2006 8:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: error connecting to UniData 6
- Replies: 9
- Views: 5874
I might have the solution now. There is a readme.txt file in the \Ascential\Datastage\ folder that has a bit about the new (as of 7.1) UniData 6 stage. It states that a script, MIGRATE.SQL, must be run on an account to make it a UniData 6 account. Another program, Privilege.B, must be run to make th...
- Wed Feb 22, 2006 4:32 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: error connecting to UniData 6
- Replies: 9
- Views: 5874
- Wed Feb 22, 2006 3:35 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: error connecting to UniData 6
- Replies: 9
- Views: 5874
error connecting to UniData 6
I've creating a new test project which is essentially a copy of a production project. This new test project is connecting to an AIX box with a UniData database - test version. We have a working production version (yes, going backwards). When I try to run an extract job against the UniData file, I'm ...
- Thu Feb 16, 2006 8:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: stored procedure
- Replies: 2
- Views: 2264
We're using DataStage 7.1 Here's an example of what we use (I've changed the names): There's a sequential text file with 1 row of dummy data -> transformer -> odbc connection, which inserts into a table (dummytable) in SQL Server and then executes the stored procedure dbo.CreateReportTable (which re...