DSXchange

I am answering my own question.
I added these columns as primary keys in XML output stage_TYPE, PROCESS_OFFICE, PACKAGE _LEVEL.

You can truncate table before loading in Oracle enterprise stage use "OPEN COMMAND"

begin
execute immediate 'truncate tablename;

Hi All, Requirement: I need to read the parameter from Oracle db table. then pass the parameter to sequencer for triggering the appropriate job. 1) scenario: ora_stage -- seq file-- -exec comand(cat file name)--nested condition (command output) -- job's this works fine but my requirement is to avoid...

evee1 wrote:Thanks. In the meantime I have found the DSSetUserStatus. I might use this to pass the return value instead of the files.

@evee1 could you tell me what are the steps to pass the value to sequencer using User status?
Thanks M

ray.wurlod wrote:

reachmexyz wrote:

anbu wrote:

Code: Select all

Trim(field,'0','L')

This will not work on a decimal directly.

Have you tried it? Decimal to string is an implicit conversion, so it should work.

I tried this Trim and converting from decimal to string also then also it is not is not working. Is there any other solution for this

chulett wrote:Divide by 100.

I got it but it is giving zeros in front of the data
001300.00
000062.00
I tried to suppress the zero but it is removing zeros at the end also as below

1300.
62.

is there any way how to remove zero infront

hi I facing some problem to find the logic to implement the logic for below requirement can any one share there ideas?? Source Sql server DB (query) Column Name 6200 6200 130000 130000 the data is like this in source I need the output as below Target (sequential file) Column Name 62.00 62.00 1300.00...

Yes you are right I used this query to check the output in oracle sql tool

SELECT study,mod_user,(TO_char( Mod_date, 'DD-MON-YY HH24:MI:SS' ))
FROM xxxx;
study mod_user date
Result = xxxx |yyyy |16-FEB-11 11:07:55

Thanks for your clarification

If i make date to timestamp then it is loading date. I tried this DSJobStartDate:CurrentTimestamp() in the transformer for mod_date column it is loading date only when the datatype is changed to date in transformer but if i change to time stamp then also it is loading date in the target column now m...

OK corrected the errors!!

Loading data from Oracle table to Oracle table There is no source for this column I created one MOD_DATE column in transformer I need Date with timestamps in the target column target table has MOD_DATE data type is DATE I can load the date but not able to load date with time stamp Any ideas I tried ...

First copy the code in notepadand and make necessary changes(for YOUR project) In the code. save it then import to your Routines then open the code and compile it should give "copile Sucessfully" without any errors Then go to job properties Select the parameters and create following parame...

I have routine which was same like your requirement see below you need to specify all Input link,output link,input stage name,output stage name etc etc..i am mentioning all the details below the code ****************************************************************************************************...

DSguru2B wrote:

Code: Select all

RIGHT(IN.COL,LEN(IN.COL) - 3))
OR
IN.COL[4,LEN(IN.COL) - 3]

...

I used this:
IN.COL[4,LEN(IN.COL) - 3][/code] ...[/quote]

Thanks it worked!!

mavrick21 wrote:What is your source? Database table or file?

its DB table