Search found 26 matches

by gmorey
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: 7800

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...
by gmorey
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: 7800

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...
by gmorey
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: 7800

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...
by gmorey
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: 7800

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.
Meena,

Thanks, but I don't understand what you mean here -> use Link varibales/ouput/rejected or DBMS.CODE or SQLCODE.
by gmorey
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: 7800

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
by gmorey
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: 7800

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...
by gmorey
Wed Mar 15, 2006 11:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UniData 6 stage - need info
Replies: 5
Views: 2416

Kenneth,

Do you know it the SQL is passed to UniData and run on UniData, or would it be translated to something else (i.e. another form of SQL?)?

Thanks,

Greg
by gmorey
Wed Mar 15, 2006 10:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UniData 6 stage - need info
Replies: 5
Views: 2416

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...
by gmorey
Wed Mar 15, 2006 10:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UniData 6 stage - need info
Replies: 5
Views: 2416

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...
by gmorey
Tue Feb 28, 2006 11:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: error connecting to UniData 6
Replies: 9
Views: 5813

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...
by gmorey
Mon Feb 27, 2006 11:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: error connecting to UniData 6
Replies: 9
Views: 5813

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...
by gmorey
Mon Feb 27, 2006 8:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: error connecting to UniData 6
Replies: 9
Views: 5813

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...
by gmorey
Wed Feb 22, 2006 4:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: error connecting to UniData 6
Replies: 9
Views: 5813

ray.wurlod wrote:Presumably the UniData file has been SQL-ized and you have not been granted SELECT privilege to it. Ask your UniData Administrator.
What do you mean by "SQL-ized"? I can't find any documentation on this, but I know it must be around somewhere.
by gmorey
Wed Feb 22, 2006 3:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: error connecting to UniData 6
Replies: 9
Views: 5813

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 ...
by gmorey
Thu Feb 16, 2006 8:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: stored procedure
Replies: 2
Views: 2222

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