DSXchange

Hi All, Inserting timestamp value into Oracle in 8.5 and 9.1. In 8.5 I am able to see the right value 25/FEB/14 09:02:18.000000000 PM In 9.1 the time stamp is being defaulted to 25/FEB/14 12:00:00.000000000 AM I tried to run with the same data and same code in both environments and they both loading...

Running the query gives me the following format.

15-JUL-13

I have my source data consists of a column EXPIRY_DATE which has got all sorts of current past and future dates. This is a daily process and for each run I need to select the records with the EXPIRY_DATE ranging between 1day minus current date upto 4Months from current date. Sample scenario: For tod...

Source is from Oracle table and the format is in YYYY-MM-DD

Hi All,

I have a scenario where I need to get data between two date values.

start date is todays date 2013-10-09
Future date is 2014-02-12

I need to output all the records between these two dates.

I've tried using (>= and <==) but doesn't work.

Any suggestions.

Regards
Kumar

Thank you Ray That worked.

Regards
Kumar

Hi,

I need to trim the first few characters ina column

Ex:
i/p

109-87654567

o/p

87654567

I tried to use trim function it didn't worked.Can anyone post some ideas to acheive this.


Regards
kumar

Hi All,

Can anyone please suggest me if there is a way of setting up ASCII 154 as a filed delimiter in a sequential file.

Regards
Kumar

Hi, I am trying to find a solution to implement the following logic in Datastage regexp_like(upper(POSTAL_CODE), '^S[0-9][0-9][0-9]$') from the above line I can find the starting value of column, but how can I find the end value in a column. Any suggestions would be greatly helpful. Thanks Kumar

Hi All, I just need some suugestions to acheive the following logic. ID VALUE 1 A 2 A 2 B 2 C 3 A 3 B 4 A The output should be something like ID VALUE 1 A 2 A|B|C 3 A|B 4 A the values should be concatenated together if they have same ID. Any suggestions would be greatly helpful. Regards Kumar

Hi All,

I just have a quick question in oracle enterprise stage in 7.5 where in I am trying to write data to a table. My question is how does stage peforms the commit on the table. Can I do a rollback once the table has been loaded.

Regards

Kumar

Hi All,

I have a requirement where in I need to strip the commas between a string.

Example:

Input:
EQ001,,EQ002,EQ003,,EQ020

The output should be like

EQ001,EQ002,EQ003,EQ020

Any suggestions would be greatly helpful.

Regards
Kumar

Hi, I need to capture duplicate records along with the master record using sort stage. Can somebody explain how to achieve this. I tried to perform this by creating the key change column set to TRUE and I tried to filter on Key change column =0 which eliminates master record. Any tips to achieve thi...

I am trying to run a job where it should prompt me with ten different values during run time. My question is how do I define these values for a single job parameter? The logic should cater for the following three scenarios It should allow me to run the job with all these ten values at once. It shoul...

Hi, I have a scenario where I need to run my job by passing values from the parameter during run time. In this instance I have ten different values that must be defined the Job parameter and I will be running with all the values at once or each one at a time.Can some let me know how can we define mu...