DSXchange

Hi

It is not resulting any output onto the Screen . When I issue the command it simply executing with out giving any error message and simply stops .


I would appreciate any help on this .

Hi I did used the query from the command line to know the category /dsadm/Ascential/DataStage/DSEngine/bin/uvsh "SELECT NAME,CATEGORY FROM DS_JOBS WHERE NAME='Coverage';" in my unix script .But I am not getting any results . Will the results get stored somewhere else or am I missing someth...

Hi DSguru,

I appreciate your response . But I have one moew question like as a Administrator only I can get the Job Category name or is there any other way around??

Thank you.

Hi

May be a dumb question . But can anybody help me like Is there any way I can find the Category of a Datastage Job from Command line .

Thanks in advance.

Thank you for your help . I used the gzip -cd option in the filter and it did worked fine .

HI

I have a big file which comes from a source in zipped format . If I try to unzip , it is giving an error because of the space issues .

So with out unzipping the file , is there any way to read the file in datastage?

Thanks.

HI All

I want to create a parallel subroutine for my datastage job . Can anybody let me know what steps I have to follow for creating a parallel subroutine .

Thanks.

HI I am using StringToDate funtion in a transformer (Parallel job) if Out_rdmNdcLstRun_seq.END_DATE="" then "" else StringToDate(Trim(Out_rdmNdcLstRun_seq.END_DATE),"%yyyy-%mm-%dd") But I am getting warnings like Conversion error calling conversion routine date_from_str...

Hi

Can anybody help me in Converting Decimal to a Packed decimal format in Server jobs.
Thank you.

DSguru2B wrote:Maybe remote shell Or install samba, this way windoze will become transparent and you can see/execute files on windoze.

So through Datastage can I invoke Samba or remoteshell and that way I can execute the DOS Commands on the files which are on Windows box??

Thanks.

But My Files are on Windows Box. I wonder is this possible still like use the execcommand stage in Sequencer??

Thanks.

Hi

I am Using Server Edition and My DataStage is Installed on Unix Box . But I want to execute some DOS Commands like from Datastage.
Is it Possible to do so like invoking the DOS Commands through DataStage ??

I would appreciate any help on this . Thanks.

HI As part of my project I also need to convert a flat file to XML file. I am just having the schema file for that which is again a flat file. How should I import the metadata using this file through xm metadata importer..I am stuck with that . Could you please let me know how should I proceed. Than...

Thanks All! It worked now after setting the DSHOME Variable.

ray.wurlod wrote:... but the count will be given in the status bar.

Hi, When i tried to get the Job count for my Project! I am getting the following Error Message! The Command issued is as follows: SH -c "dsjob -ljobs <CMK> | wc -l" The Error i am getting is: SH: syntax error at line1: '|' unexpected I tried in another way: Command Issued: SH -c "dsjo...