DSXchange

Hi Friends,

I have a input DATE column which is in DD/MM/YYYY format and the problem is Im unable to do a conversion of

CURRENT DATE - DATE and my target colum is a number.

can anyone help me coverting this in datastage server jobs.

Thanks

Hi friends,


I have a column in target as AGE which should be as (a.date minus b.date) minus weekends(saturday and sunday)


can anyone help me how to apply/Implement this in my server jobs.

Thanks

chulett wrote:Just check to see if the lookup succeeded and constrain the job to only pass rows where that is true. Use the Link Variable NOTFOUND, and Not() it to check for 'found'. ...

Sorry Chulett,
I didnt understand ur concept.

Could you please enlarge in detail.

thanks
karthik

Hi Friends,

I am using a hashfile as a lookup in my server job, as a default it will be outer join . Is there any chance that I can make this as Inner Join.

If yes can anyone help me please.

Thanks

Karry450 - it is in the documentation for the OCONV function. Date, 4 digits for the year with a "/" as separator and European format. ... But when I try this function im getting in the format of MM/DD/YYYY hh:mm:ss but is there any way to convert it to DD/MM/YYYY hh:mm:ss Thanks karthik

Hi Friends,

Thanks for your reply. but still having a problem with date conversion.

ArndW wrote:No, you need to concatentate the system variables @DATE and @TIME, i.e.

Code: Select all

OCONV(@DATE,'D4/E'):' ':OCONV(@TIME,'MTS')

...

can you please let me know what is D4/E meant?

Thanks & Regards
Karthik Chandra

hi friends,

I am using @DATE as system variable at the moment to get the date as my output .

Is there any system variable to get date+timestamp as output.

Thanks &Regards
Karthik

Hi friends, My source is oracle and also target but I am using oracle bulk load stage. But I am not getting an unique constraint error when loading the same data in target for the second time. I have checked and my target is defined with primary keys. Can anyone help is it possible to handle/reject ...

ray.wurlod wrote:There are no data types in server jobs, therefore an attempt to subtract two timestamps is undefined. You need to convert them to some numeric format (for example seconds) and subtract those. In wha ...

Can we do subraction of two DATE Data Type in server jobs?

can anyone help me...

Hi Friends, I am having two fields A(TIMESTAMP) and B(TIMESTAMP) in source and and in target I have column C( A-B) which data type should I mention here, if the column C is Decimal it is giving me a phantom error. can anyone gimme a solution to fit this condition. Thanks & regards Karthik Chandr...

The job number for the 'RT_BPnnn' subdirectory is already noted in the message - in your case 1217. So you would cd to the Project directory in question, then the RT_BP1217 sub-directory there and then finally 'vi' the file noted in the message: " JOB.282366356.DT.1473640285.TRANS2 ". Che...

ArndW wrote:What transform stages do you have? ...

Hi Friend

I have tTrade_Validation- Transformer Stage

Thanks &Regards
Karthik

Look at your TRANS2 transform stage. Somewhere in there you are performing a numeric operation (addition, subtraction, etc.) and the column data value that is coming in is a string and cannot be conve ... Hello friend, I dont have trans2 transformer stage in my mapping. plz can anyone help. thanks

Hi Friends, Can anyone help me with this phantom error in my server job,I have checked my job is working fine but getting a type of warning like ----------------------------------------------------------------------------------- DataStage Job 1217 Phantom 7411 Program "JOB.282366356.DT.14736402...

Hi Friends,,
When I am running my server job I am getting the following error



DataStage Job 1084 Phantom 14912
Program "JOB.282366356.DT.1470929422.TRANS2": Line 394, Nonnumeric data when numeric required. Zero used.


Can Anyone help please


Thanks