RE: SQL Source Editing

Chris,

Make sure your member type is set as SQL.

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: wdsci-l-bounces@xxxxxxxxxxxx
> [mailto:wdsci-l-bounces@xxxxxxxxxxxx]On Behalf Of Charlebois, Chris
> Sent: Friday, August 12, 2005 9:54 AM
> To: wdsci-l@xxxxxxxxxxxx
> Subject: [WDSCI-L] SQL Source Editing
> 
> 
> Running WebSphere Development Studio Client Advanced Edition 
> for iSeries
> Version: 5.1.2.5 Build id: 20050622_093
> 
>  
> 
> Few questions re: editing SQL Source.
> 
> 1.    When I open a SQL source member (stored in native file system as
> member type SQL), the  LPEX editor shows the source w/the date
> displaying. When I right click on the source, uncheck "Show Date Area"
> The source view remains unchanged, still sowing the date and 
> treating it
> as embedded into the source. Annoying and difficult to edit around.
> 2.    Is there away to associate a different editor when opening up
> source member using the table view (stored in the native file 
> system)? I
> know how to do this w/the file associations, but it seems this is only
> for PC stored files. I would like to use the WDSC SQL Editor.
> 3.    As a work around to #2, I created a project and exported my SQL
> source member I wanted to edit. When I opened the source w/any editor
> (SQL Editor, Text Editor) the date column displayed and is embedded in
> the source. Again, annoying....
> 
>  
> 
> The only editor that seemed to handle the date column and not embed it
> into the source was the Code Editor.
> 
>  
> 
> Any suggestions how I can use one of the internal WDSC editors to edit
> SQL?
> 
> 
> TIA
> 
>  
> 
> Chris
> 
>  
> 
>