DSXchange

I have source data loaded into an Oracle database. The fields I want to convert are defined as number(7) which are defined in my metadata as integers. The format of the date is YYYYDDD. What is the best way of converting them to dates in DataStage?

Thanks for all the help.

I tried passing to a transformer, then to the Oracle Enterprise stage with no luck. I really don't want to use the OCI stage.

Thanks

Where can I change the format for this field? The field RELA_KEY is created in the surrogate key generator stage. In Oracle there is nowhere to change the field properties for null

Thanks

I have read through previous posts for this but I don't understand why I am getting this warning. I have a job, sequential file->surrogate key generator -> Oracle Enterprise. In the sequential file I have 2 fields relationship_code and relationship_description, In the surrogate key stage I define a ...

Hi there,

There is an environment variable for this called APT_ORACLE_LOAD_DELIMITED set it to 1 and eveything works OK.

I think since I am loading an Oracle table, that I can just use the to_char function to do it.

Thanks

Hi all,

I am looking for a way to calcuate the week of the month For example, 4/01/06 would calulate to week 1, while 4/8/06 would calculate to week 2.

Is there a function in DataStage to do this?

Thanks

It looks like this will work well.

Thanks!!!!

I know that you can use "" to surround keywords, but DS generates the control file right?

So DS should be doing this. I have submitted this as a case to IBM.

Thanks

I have dates in the following format coming in as source data: YYYYDDD. Where ddd= the day of the year. When I output these dates to our warehouse I know I will have to convert them, but I also have values of 0 in these fields which I would like to convert to null. Is there anyway to do this in PX w...

Yes. Year is a keyword. That is the problem. Once I changed the column names it works fine, but what if I want the column names to be year and month?

I submitted this as a case to IBM.

Thanks!!

Hi Ray, Here is the control file... OPTIONS(DIRECT=TRUE, PARALLEL=TRUE, SKIP_INDEX_MAINTENANCE=YES) LOAD DATA INFILE '\\.\pipe\ora.324.777000d.fifo.1' "FIX 53" APPEND INTO TABLE time ( TIME_KEY POSITION(1:20) DECIMAL(38,0) NULLIF TIME_KEY = X'0000000000000000000000000000000000000000', YEAR...

Hi there, I have a table I am loading with a column named year. However the word year is a keyword in Oracle so I get the following error: Oracle_Time,0: SQL*Loader: Release 10.2.0.1.0 - Production on Mon May 1 14:06:52 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL*Loader-350: Synt...

fyi on this issue: I just talked to IBM support. This is going in as a enhancement request. Until then, I have scripted a work around. The workaround will load the table into a temporary normal table with a primary key. I then use the alter table exhchange partition...including indexes to move the d...

Hi thanks for the code.
Are you running in a Unix environment? or windows?

The issue I am having is in a windows environment. Even if I exit with an exit code it is not returning a non-zero code when using an execute command activity.