RE: Create View

I don't think there is a way to get a DATE field this way, however.

HT
Vern

At 10:50 AM 8/1/2005, you wrote:

1. the file is on Iseries and is continously updated.

2. when I says "hundreds Sql" I mean each doing something like this:

select * from x,y where x.field1 = y.field1 and y.field2 in('01' '03') order by....

The point is that the "flat" file contains a lot of data very usefull to select records and I

don't want to substring all the times with hardocde positions.

Thanks in advance
Marco

--- phil Kestenbaum <pkestenbaum@xxxxxxxxx> wrote:

> 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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.