DSXchange

Found it

OCONV(TIME(), "MTS:")

Thanks

Hi,

I am looking for a code to find just the current time from the server datetime STAMP. I want it in the format of HH:MM::SS

I tried this code:

FDat2 = Date()
FDat3=left((right(FDat2,9)),8 )

Want to find it in a routine

Thanks in advance

Hi all,

Can we use Oracle bulk load in update/Insert mode? If yes, how can it be done

Thanks

Hi all,

Can we use Oracle bulk load in update/Insert mode? If yes, how can it be done

Thanks

Hi,

If I want to check all the details of the jobs like :

number of rows processed
number os rows entered / rejected in a job,

which table stores this information?

Also if this any way that I can get a list of all the DS table like DS_AUDIT,DS_JOBS n all

Thanks

both environments / boxes. O/S? NLS setting? DataStage version are same and I am exporting .dsx

i mean the space in the transformation code.

Hi,

When I import any datastage mapping into other enviornment, all the spaces are replace by a special character ..something like p, by itself

whats the remedy for this?
Thanks in advance