RE: SQL Finding & Using

[vhamberg@xxxxxxxxxxx]

Rob

You can set the naming type in one of the menus of the SQL statement runner - and it probably persists until you change it - I think *SQL is the default - forgive my iSeries special value!!!

Vern

-------------- Original message -------------- 
From: rob@xxxxxxxxx 

> Thanks Brian. I fired up Notepad. Put a one liner in there (that 
> everyone should have) 
> SELECT * FROM SYSIBM.SYSDUMMY1 
> Saved the file as c:\mydir\TEST.SQL 
> and went to it using Explorer, double clicked on it and it fired up. 
> Keep in mind that it uses "SQL naming" and not "SYSTEM naming". In other 
> words, use the period and not the slash to separate the library from the 
> file name. 
>
> Rob Berendt 
> -- 
> Group Dekko Services, LLC 
> Dept 01.073 
> PO Box 2000 
> Dock 108 
> 6928N 400E 
> Kendallville, IN 46755 
> http://www.dekko.com 
>
>
>
>
>
> "Brian Johnson" 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx 
> 09/21/2007 11:08 AM 
> Please respond to 
> Midrange Systems Technical Discussion 
>
>
> To 
> "Midrange Systems Technical Discussion" 
> cc 
>
> Fax to 
>
> Subject 
> Re: 
>
>
>
>
>
>
> 6. Open a file that has .sql extension.