DSXchange

Thanks Participants

As you all know very well that datastage repository is stored under operating system level. so the behaviour of datastage is dependent on Operating system , that's why some times we will be encountering unidentified errors though the things are fine as per our design.

RK

The basic difference between a Transform and a Routine is
Transform is a inline function which is having one line of code
where as a routine is multiple line of code function

both are reusable

RK

Hi
Just pass the Report type as 0 / 1 / 2 followed by semicolon and give a directory path where the report file will be created

ex : select the dsjobreport as to execute after job subroutine
in the input value textbox : 3;c:\src


this is working fine

Regards
RK

Hi bala

Can you please share the process steps u have followed to send the log

to a file or the code what u have written.

your sharing knowledge is highly appreciateble

thanks in advance

regards
RK

Hi

check the option while running the job even scheduled

Limits -> warnings

and set the warning limits to unlimited

in your case it is taking the default warning errors limit which is count 50

check it while scheduling

regards
RK

Hi

Do not specify the path to the project,
but only the project name itself is enough.
DataStage knows where the project is located and doesn't need a fully qualified path. So just execute the command:


dsjob -jobinfo <project name> <jobname>

this will work

Regards
RK

Thanks kcbland

Now i got it

Thanks for your explanation and your patience and the nature you explained.

rk

thanks kcbland

For your valuable reponse

but if you don't mind

can you please give me a bit clarification regarding TX

Is TX is related to ETL or NOt

as u specified it as real time processing

Where exactly these tool will be used

Thanks in Advance

rk

can any one give me an idea of what is the basic difference between datastage TX and Datastage server/enterprise edition

In which scenario's we will use the tool datastage tx

thanks in advance

rk

Can any one tell me what is the purpose of clear status file how this will refelect cleanup resources

thanks in advance

rk

Regarding hash files most of the cases dynamic is best as the management of the hash will be done automatically. For better configuration use the Hash File calculator (Hsh.exe) which will be available with Datastage s/w

with regards
rk

Hi

i am facing this message when i am connecting to Datastage Administrator tool.

Failed to connect to host: alpha.iml.com, project: UV
(The connection was refused or the RPC daemon is not running (81016))

can any one help me with your ideas

Thanks in advance
rk

what kind of error u have faced , specify the error message

Ereplace function can replace the comma in the field , at the same time if u want to replace the comma with any other character like ('.' - dot) where u can preserve the meaning of the data. By using "" will have no impact of comma as the entire data in the field is treated as string.

Can anybody give me information regarding VOC file and what is its purpose and importance. how it will be used effectively in Datastage