RE: Create View

Mario,
1. Are you importing the "flat file" into SQL and then querying it? or Are you 
setting it up as a linked server?

2. When you say "file with (hundreds) of sql." do you mean you have hundreds of 
"rows" of data, or is it sql statements (querys) 

Phil

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Marco Facchinetti
Sent: Monday, August 01, 2005 9:11 AM
To: Midrange Systems Technical Discussion
Subject: Create View


I need to read a "flat" file with (hundreds) of sql.

The file is very simple:

A status field
A record type field
A key field
A data field

the data field is the problem since all RPG programs read it via external DS 
but of course Sql
cannot.

I'd like to define a view for each type of DS so I can use them freely via Sql 
without having to
hardcode positional substring in the statements.

Basically I know how to do it:

CREATE VIEW MUTABCAB0F (TACDCABINA, TADSCABINA, TADATARILA)
AS SELECT                                                 
SUBSTR(TBCDELEME, 1, 5) ,                                  
SUBSTR(TBDATITAB, 1, 50) ,                                 
DATE(SUBSTR(TBDATITAB, 51, 10))                            
FROM MUTABEL00F                                           
WHERE TBSETTORE = 'CAB'

The view is working but it's really poor since the fields generated are not 
referenced to the
original DS.

How can I mimic the LIKE statement of the CREATE TABLE on CREATE VIEW?

Thanks in advance
Marco


                
____________________________________________________
Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs