DSXchange

ksucheta007 wrote:Try you using ExecSH in your Before job subroutine rather than a routine to execute the Shell Script .

whats the difference?? they both mean same.


And I want to log the output of the director + capture the return code, therefore using DSExecute instead of DSU.ExecSH

I am gettitng the following error when I am trying to call a script through before job subroutine. RoutineTest..BeforeJob (): SH: /opt/home/xxx/script.sh -H mass -P parameterfile.txt: not found When I copy the same from the log and execute on the unix box, this scripts runs fine (to check for any sy...

Thanks for all your help. Wouldn't have reached this far without your help.

1) (b) Correct. But the arguments to SETPTR are purely numeric. So its ONLY the values in FMT plays the role, Whatever (low) values for Line Length and Number of Lines per Page in SETPTR wouldn't matter. 2) The documentatin for SETPTR http://infotools.ru/uv/09/0916.htm and FMT in pdf of BASIC doesnt...

a) (a) If you're trying to display fields from the hashed file itself omit the word DICT from the query. In what sense do you mean "fail"? I am trying to read the column names from the hashed file so I need the DICT. And the reason I want to look for FIELD.DEF is because it has the column...

First of all I would like to thank for the patience shown in replying my questions. I went through some homework and have few questions/clarifications a) I was trying to select just one field from DICT hashed file and used the query below. It works fine SETPTR statement SELECT FIELD.DEF FMT "13...

a) OK, try it without the ".". LIST DICT H_DAY_ID LPTR 4 It works for me with or without the ".". I tried to the statement above and it worked i.e. able to write a file wihtin &HOLD&. But now I am back to my same question.. As the output from >SETPTR 4,1000,200000,0,0,3,...

you have to use a function and loop around it.

ray.wurlod wrote:LIST.DICT is not SQL so does not take a terminating ";" character.

Even when I remove the ; , the same happens (i.e. the file doesn't get created in &HOLD& directory). Basically I want to obtain result from LIST.DICT and parse the column names.

ray.wurlod wrote:The file is overwritten if no new SETPTR command has been executed.

I have executed the setptr prior to the list.dict statement. There isnt any file.

I am looking for all the records from the database where the first four charters Change the 1,3 in the code to 1,4 then????????? If you are looking for dynamic join and based on your requirement. 3. In the output, I am looking for all the records from the database where the first four charters in t...

Looks like a mismatch of datatype.

In the oracle stage, you might be having a datatype for a field defined as long. But in the database same field is of different datatype.

Thanks, I am able to view the file. However, does the SETPTR works only for select statements? I tried the below SETPTR 4,1000,20000,0,0,3,BANNER listtest,BRIEF LIST.DICT HashOther LPTR 4; But I don't see the file getting created. If I have SETPTR 4,1000,20000,0,0,3,BANNER hashedfile,BRIEF SELECT * ...

Hi, Thanks for the response. I executed similar statement SETPTR 4,1000,20000,0,0,3,BANNER MyOutput,BRIEF SELECT * FROM HashOther LPTR 4; a) But I am not able to cd (change directory) to &HOLD& or read the MyOutput file. when I execute find . -follow -name HashOther I get the result ./&H...

You are right, I didnt read that first post properly. But highlighted stating same database or dblink to write the query. EXCEPT, MINUS statemetns for huge tables takes potentially long time. left outer join works pretty well in that case. Coming back to the question posted Do you have a DBLINK (I p...