DSXchange

Hi !

I use JOB SEQUENCE design where I rn three jobs in parallel and all three jobs read from the same hash file .

I wonder if its ok and it not corrupt data ? How to improve perfomance of reading . Whats the sharing options ?

I wonder if any way to change all ODBC connection names in project by any command ?

Hi !

I wonder if any way to change all ODBC connection names in project by any command ?

If I can insert Enviroment Variable directly to ODBC nam or only through JOB PARAMETER ?

Use

PHONE.area_code : PHONE.prefix : PHONE.number

I need to read char ( in column metadata) as varchar from database
and get warning So its not the same for DS

Hi !

If any way to convert char to varchar inside DS ?

Hi !

The option of Clean up resources is greyed in Director.

Does anybody know what is the problem ?

Sorry , it working !

the both your codes .

But can you explane how to create UV table in Project Directory ?Or where to read about it ?

I get


Result = DataStage/SQL: Table "H_DW_DIM_FARMACY" does not exist.

THe hashed file not written as the UV table .

How to create UV table ?

Arg1 = H_DW_DIM_FARMACY

Test completed.


Result = Retrieve: syntax error. Unexpected sentence without filename. Token was "".
Scanned command was COUNT 'H_DW_DIM_FARMACY'

How to remove ' from Command . What is his char code ?

I dont understand what happen but still the name is quoted I get error with two your options: Result = Retrieve: syntax error. Unexpected sentence without filename. Token was "". Scanned command was COUNT 'H_DW_DIM_FARMACY' I need to get COUNT H_DW_DIM_FARMACY Have a nice day

I dont want to hardcode the hashfile name . I want to pass it to routine

So your option not suitable for me

Any ideas ?

Hi !

I need to run COUNT filename command without " in file name

COUNT HASH1

not

COUNT 'HASH1'

How to remove ' from command before I do DSExecute ?

I have The "Add Job" only in Job not for Job sequence.

And in Job Control the code not editable.

Are you use usual Server Job to run other jobs ?

Batch job is nothing but the code is written by DS when add a job in the jobcontrol

where i can see the code of batch ? Can I change it ? Is it good technique dont use the job sequence