DSXchange

Hey,
I am trying to run a DS job from command line using Dsjob and the job status code i know are generally '1' for success and '3' for Abort. Could anyone guide me what are the other status codes that can be found and their values like status code for '2','4' etc.....

Thanks in Advance.

Thanks guys.
The issue has been resolved. I have a used a constraint to reject rows which do not fall within the date range., i.e.. iconv(arg1[1,10],"D-DYM") > -78525.

Hey Whale, Year 0016 falls below the minimum date value required for both datatypes, hence the rejection by SQL Server. Ask your business folks on how they want to address this. May be you can assign a default date (like 1900-01-01) for a date which doesn't fall within SQL Server valid date range. ...

Hey Whale, Sorry for late response. Actually the issue has not been resolved. The issue is that sql server is not accepting a date '0016-01-01 00:00:00'. It is one of Y2k problem. Any suggestions please... Thanks. iwin, Your reply causes wonder :roll: whether the problem was solved or not. If it is ...

Thanks The valid date ranges for SQL Server Date datatypes are as below: Data type Range Accuracy datetime January 1, 1753, through December 31, 9999 3.33 milliseconds smalldatetime January 1, 1900, through June 6, 2079 1 minute Whale.

Hey Ken, I just noticed that the min date value in oracle is "0016/11/10" where as for Sql server it is "1990/01/03". I am assuming this maight be the problem. Any inputs please. Thanks Do a select min(yourcolumnA), max(yourcolumnA), min(yourcolumnB), max(yourcolumnb) from yourso...

Hi Ken,
Yes, these are only date columns defined as not null in source oracle table.

Thanks

kcbland wrote:Are these the only date columns? Profile the source date columns and make sure there are no NULLs or invalid dates.

Hi , Source Oracle: Datatype :Timestamp Length : 38 Scale:0 Target Sql Server: Datatype : Timestamp Length: 23 Scale :3. Thanks. Hi, I am getting the date from oracle in "yyyy-mm-dd hh:mm:ss" format with column generated SQL and defind as timestamp datatype. Coming to Target Sql server it ...

Thanks rohit,
I did check it. There are no spaces or nulls in date field. And also i dont get the row which is generating this error

Krazykoolrohit wrote:are there any spaces or blanks in dae field? check for them in oracle table by firing a query.

I dont see any information after this message.

I_Server_Whale wrote:Can you post the information after this error message:

Code: Select all

" SQLSTATE=22008, DBMS.CODE=0 
[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver]Datetime field overflow" 

I mean, the data for which(dates) it fails.

Whale.

Hi, I am getting the date from oracle in "yyyy-mm-dd hh:mm:ss" format with column generated SQL and defind as timestamp datatype. Coming to Target Sql server it is also defined as timestamp datatype in Datastage. I am getting this error after 9K records are loaded. I viewed the data and th...

Hi, I am trying to load a Sql Server table sourced from Oracle table with Effect start date and end date as of two date fields. After loading 9k records i am getting an Error: " SQLSTATE=22008, DBMS.CODE=0 [DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver]Datetime field overflow&...

The one mentioned in post is transformer routine with 5 args. Only transformer routines can take more than one args directly . You just have to create a new routine using DS Manager or Designer. Procedure to create routine is available in the PDFs or help for DS. Its very easy. Thanks Kirti. I will...

Probably the easiest way to do this is to write a routine to generate a long string which produces all the output rows with LF between. Write this to a sequential file (as a single VarChar column) with 000 as the delimiter and quote character and then read from the same sequential file using whatev...

Hi, I have a source row which has a format as follow: Cu_id---Cu_nm---Start_date---End_date----Revenue% 10----ABC-----09/01/2005---10/11/2005--- 40 I need the Target to be as follows: Cu_id---Cu_nm---Date----------Revenue% 10-----ABC------09/01/2005---- 40 10-----ABC------09/02/2005---- 40 10-----AB...