DSXchange

Figured it out. Closed.

Solution to convert char (YYYYMMDD) to Timestamp (YYYY-MM-DD HH24:MI:SS) in "Server" edition
In the transformer
OConv(IConv(Dr.REPORT_DT, 'D/YMD[4,2,2]'), 'D-YMD[4,2,2]') : ' 00:00:00'

Hello: I have source date colum (report_dt) coming in as CHAR in the following format: YYYYMMDD (20120606) and I would like to convert into Timestamp so that I can load it in Oracle table as Timestamp (2012-06-06 00:00:00) Parallel version has a StringToDate(report_dt, "%yyyy%mm%dd") funct...

So, the code would be:
SecondsSinceFromTimestamp(Dt_Tm_2, Dt_Tm_1) <= 3600 (60 minutes)

Please correct me if I am wrong..

Thanks all for your replies.

chulett wrote:Then * 60. ...

DataStage: 8.1 Enterprise Database: Oracle 10g I have 2 date columns (Timestamp datatype); one date comes out of driver query and other comes out of dataset. I want to subtract the date coming out driver query (Dt_Tm_1) from the dataset (Dt_Tm_2) in Transformer to check for <= 60 minutes. (Dt_Tm_2 -...

Ray and chulett,

Thanks much. Problem solved. Tried both ways.. BTW, I was not doing IConv right....

-Sam

Hello: I get an external file that has "Record Date" as MM/DD/YYYY HH24:MM (11/19/2009 18:24) format.. The rows abort trying to load into oracle table due to the date/time format. In oracle that 'Record Date' is defined as Timestamp (YYYY-MM-DD HH24:MI:SS). Upon using search functionality ...

Thanks to all who replied. Looks like passing it in sequence or batch job would be the only way to go... So, if I were to run the dataset job only I need to make sure the parameters I pass in are UPPER CASE in dataset as well as the load job that is using the dataset jobs. Thanks again, -Sam Paramet...

New to parallel jobs. I created few datasets that will be used in the Lookups. Presently all datasets are created under /dataset directory just fine. But I want to create datasets under each project directory (we have DWDEV, DWTEST, DWSTAGE, etc...) So for datasets here is what I did /datasets/#DBNA...

This is my first enterprise job and I am having the exact same problem the original poster had (if lookup fails (either matching record is not found or table/file is empty) the Timestamp data field is getting assigned to "*********").... I am getting ********** and the record is not insert...

Ahh.... how did I miss this one? Thanks chulett, this tip worked like a charm.

chulett wrote:Generally, one would check if the value is greater than zero. ...

I have a column (Total_Amount; Decimal(38,2)) that I want to check in the transformer stage. I want to check if its positive number and put some logic... I know the logic but cannot figure out a way to check if the column is positive?

Any pointers please...

Thanks!!
-Sam

We are using DataStage 8.0.1 Server edition and I would like to know if I can open projects from Designer instead of going back and forth using Director.

Thanks!!
-Sam

We are using DS Server edition 7.5.2.. I have installed new version 8.0.1 and plan to upgrade existing jobs to 8.0.1 server edition (will move to Enterprise edition (parallel jobs) after successful migration of server jobs from 7.5.2 to 8.0.1. I imported the project in 8.0.1 (was exported in ver 7.5...

Yep.. col1 is the primary key... I had to create 2 links for insert and update jobs.. Thanks all !!

I am using OCI stage to insert/update rows in Oracle database. I am using update/insert query. I want to insert all rows but update all but 1 row. So in the OCI stage, I use user defined SQL INSERT INTO <TABLE> (Col1, Col2, Col3, Col4) VALUES (:1,:2,TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'),:4); UPDATE <...