DSXchange

Dear All I am trying to run a simple job through dsjob in unix. The job is not having any parameters. When I run through dsjob I am getting an error. In Dev Guide -1004 responds to "job compilation" .I tried after compilation,still geting an error. Command: ------------ bin/dsjob -run ric_...

Its working.
The thing is I created Message handler ----> Edit Choose message handler--> New.
Thats where it was NOT Working.
-----
When I created Edit Local runtime handler for job. It was working.

Why is this...?

Hi Ray

The log color is not changing ,its still yellow in color. And also in the beginning of the job there is no message handler logs.

In one line its Collection of nodes or pools(disk and scratch disk pool). At certain times, we run some stages or some specific jobs which requires more physical storage space (staging area). At these times we need more nodes for processing. We can also call this as reserve storage area. Example of ...

Dear All For the above warning message I am trying to write Message Handler to "Demote to Infomational". But still I am getting warning. I am creating a new rule for the handler through DS Director--> selecting Log message and the --> Add rule to message handler. My message handler : -----...

Thanks for that ArndW

If am not using "export" in disk pools, my job will always complete with WARNING, that it has used default disk pool. So in order to avoid that I am using export.

Or is there any way to suppress the warning other than changing default.apt.

No I did not change any setting in FileSet stage.

More over the FileSet Stage--> Advanced Tab , we have only one active dropdown taht is buffering mode.

Is that ok to use export in config/default.apt

Dear All While creating simple FileSet we got the following warning "When checking operator: No nodes with a disk in the "export" resource pool; using the default disk pool instead." After seraching and reading document We changed the Config file/Default.apt as follows. resource ...

Dear All After searching , I am posting this question. In server jobs we have Hash file,which is Insert/Update using a particular unique key. In the same way I tried using DataSet stage in parallel,but this does not work as insert/update using key. Is there any way to use Dataset as Update/insert , ...

After searching its resolved.
We just logged int to DS administrator
went to projects -> Environment variables--> User defined.
Added new variable PWD of type STRING and value = Full project path.
Job is completing without any warnings.

Thank you.

Dear All While running any job I am getting an Warning as follows. Warning: the value of the PWD environment variable (/<Path>/Ascential/DataStage/DSEngine) does not appear to be a synonym for the current working directory (/<Path>/Ascential/DataStage/Projects/<Project_Name>). The current working di...

Ok.On your way.. You want to delete all the records in the table , or only the records that have been loaded yesterday. If only the records loaded yesterday ------------------------------------ 1. Use DATE parameter as key and use ORACLE OCI stage only (not bulk) 2. Write user defined sql. 3. Delete...

Your question is not clear is it DELETE or TRUNCATE. if delete then are you using any key for deletion. If deletion then I suppose you can not do it through BULK loading. If TRUNCATE/LOAD then use ORACLE 7 BULK LOAD to create Control file and load using sql loader(sqlldr). In CTL you can specify TRU...

I got the desired output. using the command as follows.

Subst = Field(Output, @FM, 3)

where 3 is the third formated result.
thanks for reply Mr.Ray

Can you please tel me how to delimit a the following output

I am using Field function as follows
Subst = Field(Output, " ", 1)

But I am not getting value,how to delimit the following
UASL_CIRCLE_CD

MU

1
Hint please