DSXchange

Hi Mr. Ray , I have created one file say getname where i have included all select commad and running through uvsh in unix prompt . Ex uvsh < getname > test I am getting list of hash file name but not able to set linesize and page size for each result i am getting header and footer . Pl. help . Regar...

Great !!!!

Thanks Mr Arndw ,

We have followup your first suggestion , now we are able to create same hash file name

Thanks again

Regards

Arun

Hi , In our devlopment server prjoect directory mount point reahed 100 % and this cause one hash file got corrupt ( unable to make entry in VOC file ) now we tried to analyze , clear , delete this hash file from universe but could not . giving following error - ( Hash file name is H_CUST_PHONE_CAF. ...

Thanks Mr. Ray ,

Now we have resolved our hash file related problem with your good
cordination .

Regards

arun

Good morning Mr. Ray , Wish you & family very very happy new year . Now we have analyzed all unwanted hash file and we need to clear and delete the same , I am able to see and get count hash file which is created in project director but pl advice how to get count , clear and delete hash file whi...

Excellent guide !!!! , Now linesize problem resolved , only one problem i am facing , when run command to get hash file name then after 40 - 50 line it aborted , I think some memory problem , pl. help

I am running following command from my project directory and getting output in file ( test ) /u01/app/datastage/product/Ascential/DataStage/DSEngine/bin/uvsh "SELECT CATEGORY AS CATGRY FMT '25L', DS_JOBS.NAME AS JOB_NAME FMT '25L' , MAX(EVAL DS_JOBOBJECTS.'@RECORD<6>') FMT '45L' AS LINK_NAME FR...

Hi Mr. Ray ,

I am also able to get result from uvsh command , but unable to set
linesize (TERM 200) , pl. help .

Thanks and Regards

arun

Thanks Mr. Ray I have modified SQL and it is working fine , but after result few line it is getting abort . yes , we are going to take support from Ascential. Error - CRITICAL ERROR! Notify the system administrator. Abnormal termination of DataStage. Fault type is 11. Layer type is Command Language....

Hi Mr. ray , I got result with using group by class but , if any job using two hash file then i am geeting only one hash file name , i think because of max and group by class , then I remove Max and group by class and again ran , but is is not working , pl help. ( Error - Internal problem with ALIAS...

Hello Mr. Ray ,

I have taken out result through copy resul and past in notepad one by one , In SQL we can create file by sppol file name and spool off ,
is it possible to take output is text file .

Thanks Mr. Ray , I have added category also , working fine but result is not comming in one line , for ex. CATGRY.... CSA\S2Xfm JOB_NAME.. J1CsaXfm LINK_NAME. Task_Id CATGRY.... CSS\S2Lor JOB_NAME.. J1CssLor LINK_NAME. DateMin CATGRY.... CST\S1Mas JOB_NAME.. J1CstMas LINK_NAME. H_CST_LOGINID_DETAILS...

Hi Ray , If omit line this will give result for all hash file not only selected , but it will solve my problem , i omit line and put this is in select column for getting hash file name but not working giving error . select DS_JOBS.NAME AS JOB_NAME FMT '45L' , DS_JOBOBJECTS."@RECORD<6>" FMT...

Hi , I am able to get the name of job where a particular hash file using through Universe command , but I have a list of hafile and to get job name I have to run command one by one for all has file name , can any one help me that from that is it possible from one routine or from job ?? command I am ...

Hi , We had also same problem , but we resolve this problem with Unix shell scripting, we had got confirmation that source file having standard head and trailer , then we create unix script which check header and trailer and call this script in datastage job - before job subrotuine . With Regards Arun