DSXchange

my project requirement is like this I have a fixed width file. Now data has to be tranferred from fixed width file to oracle. to achive this Iam using Sequential file --> Transformer --> oracle enterprise sample data +320+ 20070301 +01+00012+ 00000000 + 00000000 +00001 +319+ 20070401 +01+00012+ 0000...

Hi,

In director,

step 1 :

job -> cleanup resource -> (in job resources dialog) Locks -> show all-> itemid (try to check for that job name and note pid)

step 2:

(in job resources dialog) processes -> show all -> select the PID of step 1 -> select logout.

I agree with ArndW, answer will be a,b,c,d,e

I agree with ArndW, answer will be a,b,c,d,e

Ereplace() function is working fine, but didn't find similar function in PX.

Use System variable @LOGNAME in datastage job itself.

To my knowledge we can use this system variable only in server jobs.

ArndW wrote:Krisna - those aren't naming conventions, but limitations from the product on what characters jobs can contain. ...

Hi,

I agree, I mean to say that when we are using naming conventions also we have to follow the above mentioned limitations.

In transformer we can use ":" for concatenating two strings.

The modify stage alters the record schema of its input data set. The modified data set is then output.

I think modify stage cannot be used for concatenating.

In transformer we can use ":" for concatenating two strings.

The modify stage alters the record schema of its input data set. The modified data set is then output.

I think modify stage cannot be used for concatenating.

We can USE 'dsjob' command at unix prompt to veiw the status code and other information of the job. dsjob -report <project> <job|jobid> [DETAIL | FATAL] dsjob -jobinfo <project> <job|jobid> some of the job status codes follows like this. DSJS.RUNNING = 0 --> This is the only status that means the jo...

yuva010 wrote:I am new to this tool,

For any Data Stage job can we have dash(-), underscore
(_) to classify it?

Datastage job name should start with alphabet and can have alpha-numeric and also a special symbol underscore(_)

Naming standards(conventions) are not common for all the datastage clients. Naming standards(conventions) differs from one client to another client.

As suresh said, using of Copy stage after join stage is working fine

from unix command prompt u can try like this. /opt/dsSoftware/Ascential/DataStage/DSEngine/bin/dsjob -logsum "project" "job|jobid" or from unix command prompt u try like this. change the directory as( /opt/dsSoftware/Ascential/DataStage/DSEngine/bin ) then use dsjob -logsum "...

in pivot stage properties, select outputs tab -> select columns -> give the single column name as 'col1' -> in derivation give all the input column names separated by a space. for ex : - Column name | group | Derivation | key | SQL Type col1 a b c d e integer it works fine