DSXchange

thanks for youre response meena, Deepak.


The source date format is dd-mm-yyyy,

there is no timestamp in source.

Basing on this information is this correct

oconv(iconv(DSLINK2.COLUMN NAME, "DYMD"), "D-YMD[4,2,2]")


Thanks,

Hi,

i have source sequential file Date (varchar),

Target oracle database Date(Timestamp).

in transformer i am using the oconv like this

oconv(iconv(DSLINK2.COLUMN NAME, "DYMD"), "D-YMD[4,2,2]")

please correct me from wrong.

Thanks for your help.

Try actually using the name of your project and the name o ...[/quote]

Hi Andrw,

i tried with myproject and myjob only, i mean

myproject = datastage project name

myjob = datastage jobname in that project

Thanks

Hi ray,

i tried with this dsjob -lognewest projectname jobname it is giving a message newest id = 50, statuscode = 0.

please help me how to use these dsjob commands, i searched in forums

But i am not able to find.

Hi, i want to know the complete log report of a job, if the log cleared by user in datastage director, is it possible to see the log report using this command. dsjob -lognewest, when i am trying to run it in unix the following error Invalid arguments: dsjob -lognewest [-useid] <project> <job|jobid> ...

Thanks chulett,

By this you understood how much knowledge i have in crontab, so please provide any documentation, usage, architecture.

Just give the information where can i find the documentation related to that from ETL perspective.


thanks in advance.

Hi,

I am trying to know more information regarding CORNTAB usage,
please help me.


thanks in advance.

ArndW wrote:Could you post your exact command stage command for invoking the job - the message makes it likely that you have a syntax error in that command. ...

Exactly, i checked the syntax and now it is working fine.

Thanks.

Hi, i have a jobsequence, it is calling another job That job is using a dsjobcmd:- dsjob -report , when i run the jobsequence it is finished, but the serverjob in that sequence is aborted. The log report:- Fatal error:- JobControl (fatal error from 1): Error: Unable to run new dsjob command 255. ple...

Thanks chulett for your response. The custom, build. wrapper options are with datastage client interface without using third party tools are available from enterprise edition(parallel Extender) , but now i am trying to implement this functionality in sever jobs(7.5). correct me from wrong. So please...

Hi,

i need to schedule a job for continuous run using datastage director,

for ex:-

job name : -- abcd

After finishing the job it has to restart again.

is it possible using datastage director.

please give your valuble suggestions.

thanks in advance.

Thanks chulett.

Friends, i am getting the following datastage phantom errors DataStage Job 12 Phantom 21602 Program "DSD.StageRun": Line 301, Square root of a negative number. DataStage Phantom Finished DataStage Job 12 Phantom 21603 Program "DSD.StageRun": Line 301, Square root of a negative nu...

Gurus,

I want to design an ETL job to send out email when there is no abort or warnings.

Your valuable suggestions are welcome.

Yes...The job2 when ran individually is doing perfect.I dont see any reason, why when it was called in sequencer is not responding!!!!!!!