Search found 12 matches

by RaviM
Fri Apr 14, 2006 8:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: I am getting error while calling UtilityRunJob from a routin
Replies: 7
Views: 4173

Yes,

This UtilityRunJob working fine when i am calling from server job.
giving error only when i am calling from user defind routine.

DSguru2B wrote:Did you try to test the routine before even running it. The test should have what all arguments to pass in order to see the result of the job.
by RaviM
Fri Apr 14, 2006 8:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: I am getting error while calling UtilityRunJob from a routin
Replies: 7
Views: 4173

I am getting error while calling UtilityRunJob from a routin

Hi All, I am getting error while UtilityRunJob from user defiend routine. below is my code. ------------------------------------------------ $INCLUDE DSINCLUDE JOBCONTROL.H Arg1 = "TestJob" Str = UtilityRunJob(Arg1,"","","") Ans = Str -------------------------...
by RaviM
Fri Mar 10, 2006 2:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DB2 Load error
Replies: 7
Views: 4566

Working gr8 Thanks dude After your sql put the words: "WITH NONE". So if your sql look like: Insert into table1 (col1,col2) values(?,?) Change it to: Insert into table1 (col1,col2) values(?,?) with none I believe that your target table is a non-journaled table, and you need to either set t...
by RaviM
Fri Mar 10, 2006 11:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DB2 Load error
Replies: 7
Views: 4566

DB2 Load error

Hi All, I am gettinng below error while loading into AS400 through ODBC stage ERROR : [DataStage][SQL Client][ODBC][IBM][CLI Driver][AS] SQL7008N REXX variable "SBMSCHIR " contains inconsistent data. SQLSTATE=55019 Has anyone any ideas........... The OS Im using is Windows 2000 Thanks
by RaviM
Wed Feb 15, 2006 6:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to call windows script from datastage?
Replies: 2
Views: 2133

How to call windows script from datastage?

How to call Windows script from datastage
My script name is abc.vbs ( C:\abc.vbs)
by RaviM
Thu Jan 19, 2006 3:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ds_uvput() - Write failed error
Replies: 1
Views: 1348

ds_uvput() - Write failed error

Hi,

I am getting "ds_uvput() - Write failed" warnings while writing data into hash file. how to solve this.

Thanks in advance
by RaviM
Wed Nov 16, 2005 10:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error loading DATE into ORACLE
Replies: 5
Views: 3313

Error loading DATE into ORACLE

Hi,

I am having problem while loading DATE value in to oracle.

Input value is : 16-NOV-05,

Query in Oracle stage : INSERT INTO TEMP (Load_Date) VALUES (:1)

ERROR: ORA-01862: the numeric value does not match the length of the format item.

please let me know the solution ASAP
by RaviM
Fri Nov 11, 2005 10:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Oracle stored procedure in ORACLE stage?
Replies: 2
Views: 2322

How to Oracle stored procedure in ORACLE stage?

Could plz help me in calling stored procedure,
How to Oracle stored procedure in ORACLE stage?
by RaviM
Wed Sep 28, 2005 9:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage agregator is giving error "Invalid Number&quo
Replies: 3
Views: 1953

Re: Datastage agregator is giving error "Invalid Number

That is bcoz of char/null values are comming in charge field.
by RaviM
Wed Sep 14, 2005 1:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to replace null to something.
Replies: 9
Views: 4910

Re: How to replace null to something.

Hi, I have job where I am reading data from DB2. Now the column I am reading can have null as well. I need to replace that null to "NONE". I did try with CHANGE function but it only works with empty string and not NULL. Is there any inbuilt function or do I need to write custom. Any idea ...
by RaviM
Wed Sep 07, 2005 2:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: nls_map_buffer_out() - NLS mapping error
Replies: 1
Views: 5053

nls_map_buffer_out() - NLS mapping error

why i am getting "nls_map_buffer_out() - NLS mapping error" error ?
i am loading data into seq file with comma delimiter
by RaviM
Mon Aug 29, 2005 2:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to extract file data which is in BW server ?
Replies: 1
Views: 1213

How to extract file data which is in BW server ?

we have file which is sitting in SAP-BW server , what parameters i need to set in SAP-BW extract plug in so that i can read it in a job ?