DSXchange

So Do i need to try as :


ED VOC OVERWRITING 'ProcKeyLookup' ;

???

It is not taking OVERWRITING as the filename though ..Anything wrong with my syntax?

when I am trying to add voc it is saying :

Error is not a new record. Aborting ...

Seems like the entry is already there .Can we delete the existing entry from voc and start from scratch one more time ?

Thanks a lot Ray.I am getting like this :

LIST.ITEM VOC "ProcKeyLookup" 18:53:26 02-08-12 PAGE 1

ProcKeyLookup
001 F
002 ProcKeyLookup
003 ProcKeyLookup/D_ProcKeyLookup

When I did it is saying :


LIST.ITEM VOC ProcKeyLookup

Retrieve: syntax error. Unexpected filename. Token was "ProcKeyLookup".
Scanned command was LIST.ITEM VOC ProcKeyLookup


Did i do any thing wrong?

Hi Recently we have migrated to 8.5 version and I am trying to create indexes on the hash file . I was able to create VOC entry successfully after that with the syntax : >CREATE.INDEX ProcKeyLookup PROC_CODE Unable to open "DICT ProcKeyLookup". >BUILD.INDEX ProcKeyLookup PROC_CODE Unable t...

Hi We have recently migrated to 8.x version .But I am just wondering like , in our old version we used to query against the repository on DS_JOBS and get the results for some audit purposes . Is this possible to query in the similar way in 8.X as well? I would really appreciate all your inputs regar...

sorry , I mean to say , when I used the logdetail , instead of getting the details , I am getting the message as the Log has been auto purged .If I use the option Logsum , I am getting all the 3 logs that ran on the day, But I want to limit the log to only the Latest . So Not sure how to deal with i...

Is there any way to find out the file name details that is used in a sequential file stage . I am able to get the row count , but want to find out the name of the file that is used in that particular stage.

I would really appreciate any information regarding .

Hi I am seeing 3 different logs of a Job that ran on the same day.Among them I want to take the newest log from them. So I have used command:lognewst and got one event id . I have used the same in the logdetail , but it is saying the log has been Purged . So just wondering how to deal with it . Mess...

Hi Brad

We are looking to perform the same query Banding , But we are on 7.5.2 version .Do we have that option available in this version ?

If it is available in 8.X version , can you please let me know how can we do that ?

Thanks a lot for all your time and help .

When i run the ds job I am getting 1.8 M . When i run the same sql on Toad its getting 2.4M (Correct count). DataStage not showing error in the logs and its not suppressing any logs. Please help me in the above issue

Thank you . The options worked out.

Hi All Is there any way to retrieve the value of the parameter APT_CONFIG_FILE used inside the job at the design time . When I have used the /dsadm/Ascential/DataStage/DSEngine/bin/dsjob -logdetail projname jobname this is giving the run time information of the parameter .But I am interested in gett...

Thanks Ray.This is really really helpful .Thanks for all your direction.

Thanks Ray .

But I mean can I specifically tell some table definitions to delete ? Cause it is becoming very hard to manually go and delete them from the datastage Manager .

AS we are sure some of them are really not useful , am trying to figure out all the possible ways.