Hi All, is there any support in webfocus to access a file (CSV) located in the Iseries integrated File system (IFS)?

This message has been edited. Last edited by: Lloyd,

As a csv is a text file, I can'e see why not.

Have you tried yet ?

Tried..is such a subjective word....

I did scan the online help, and didn't come across any references to the IFS. I then looked at our DB2 client to see if there was anything there that might help and saw nothing help full. (Actually I tried to get to the IFS directory and it crashed!)

I haven't accessed a text file through WF, so I am pretty much a nubie there....

I'm not familiar with IFS, but if WebFOCUS can see the file and FILEDEF it, then it should be able to read it.

Because it is a CSV, you will need to create a master file for it.

OK, so I tried following a forum post for something simialr. But I am getting errors.

  
MASTER FILE:

FILENAME=SYNCRLM, SUFFIX=COM     , $
  SEGMENT=SYNCRLM, SEGTYPE=S0, $
    FIELDNAME=FACILITY, USAGE=A23, ACTUAL=A23, $
    FIELDNAME=RLMORD, USAGE=A14, ACTUAL=A14, $
    FIELDNAME=RLMLIN, USAGE=A6, ACTUAL=A6, $
    FIELDNAME=PCTL, USAGE=A10, ACTUAL=A10, $
    FIELDNAME=SKU, USAGE=A30, ACTUAL=A30, $
    FIELDNAME=UPC, USAGE=A20, ACTUAL=A20, $
    FIELDNAME=RLMACT, USAGE=A7, ACTUAL=A7, $
    FIELDNAME=TOWVE, USAGE=A11, ACTUAL=A11, $
    FIELDNAME=WAVED, USAGE=A11, ACTUAL=A11, $
    FIELDNAME=PIKQTY, USAGE=A11, ACTUAL=A11, $
    FIELDNAME=PAKQTY, USAGE=A11, ACTUAL=A11, $
    FIELDNAME=PCKHLD, USAGE=A11, ACTUAL=A11, $
    FIELDNAME=SHIPQTY, USAGE=A11, ACTUAL=A11, $
    FIELDNAME=CANQTY, USAGE=A11, ACTUAL=A11, $
    FIELDNAME=ORDQTY, USAGE=A11, ACTUAL=A11, $

  
FEX:

-SET &ECHO='ALL';
SET ASNAMES = ON
SET PCOMMA = ON

REMOTE DEST = MK400NEW
REMOTE USER=MK_APPS
REMOTE PASSWORD=mk@99$
-REMOTE BEGIN

-SET &FILEPATH = '//MKI7WHL/';

-SET &_FILE = 'DRV/ORDSTATUS2013101106.CSV';
-SET &FULLFILENAME = &FILEPATH | &_FILE;

FILEDEF SYNCRLM DISK "&FULLFILENAME"

TABLE FILE SYNCRLM
PRINT FACILITY
END
-RUN

-REMOTE END

  
RUN:

 SET ASNAMES = ON
 SET PCOMMA = ON
 REMOTE DEST = MK400NEW
 REMOTE USER=MK_APPS
 REMOTE PASSWORD=mk@99$
 -REMOTE BEGIN
 -SET &FILEPATH = '//MKI7WHL/';
 -SET &_FILE = 'DRV/ORDSTATUS2013101106.CSV';
 -SET &FULLFILENAME = //MKI7WHL/ | DRV/ORDSTATUS2013101106.CSV;
 FILEDEF SYNCRLM DISK "//MKI7WHL/DRV/ORDSTATUS2013101106.CSV"
 TABLE FILE SYNCRLM
 PRINT FACILITY
 END
 -RUN
 -REMOTE END
 (FOC229) ERROR READING EXTERNAL DATA FILE: SYNCRLM
 0 NUMBER OF RECORDS IN TABLE=        0  LINES=      0
 (FOC1400) SQLCODE IS 229 (HEX: 000000E5)
 : ERROR READING EXTERNAL DATA FILE: SYNCRLM
 L    (FOC1405) SQL PREPARE ERROR.
 -*-MRNOEDIT END

The part I am not sure about is how do I access a file in the Iseries IFS. Any one know how to code this?

This message has been edited. Last edited by: Lloyd,

Hi there,
I seem to recall that I did read a flat file on IFS many moons ago, but I cannot remember how.
Hopefully someone that uses WebFOCUS on IBM i will come to your rescue ;-)

Your Master File is on the right track - so obviously you need to overcome the "ERROR READING EXTERNAL DATA FILE: SYNCRLM"

Have a look at the "Adapter Administration" and "Server Administration" manuals on http://documentation.informati...ilders.com/wf77x.asp as a start. The Adapter Admin manual has references to accessing flat and delimited files on IFS.

I can't remember whether IBM i is case sensitive in terms of the "unix" file names. If it is, you may need to have a lowercase filename in your FILEDEF.

Have you tried the following type of filename convention?
/QSYS.LIB/MYLIBRARY.LIB/MYSRC.FILE

And then, another possible option just to get started: copy your CSV file into one of your APPS directories e.g. into BASEAPP.

Then try the following FILEDEF:

FILEDEF SYNCRLM DISK baseapp/ordstatus2013101106.csv

Hi,
I found this:

How to Access IFS Files
IFS access follows the standards of a number of other platforms for FILEDEF, USE, and
APPS, but is most like UNIX because the file names follow the same rules. The following is
a summary of the respective commands and conventions

FILEDEF ddname DISK filename [(options]

USE
filename [AS name]
END

APP MAP MYAPP directory

where:
ddname
Is the reference name for the file being opened.
filename
Is either the relative path or full path and the file name (for example, myfile.dat,
acctng/myfile.dat, or /home/iadmin/acctng/myfile.dat).
options
Are the available access options such as LRECL or RECFM.
For more information about FILEDEF options, see the Stored Procedures Reference.
name
Is the optional alternate name of the Master File.
directory
Is the full path name of the directory (for example, /home/iadmin/acctng).
Use of a relative path name is not recommended, since this varies with any given connection
to the server. Use of environment variables or shortcuts (for example, $HOME or ~) is not
supported in any context.

Hi I actually figured it out, over thinking made it seem harder than it actually was....

All I needed to do was reference the IFS folder and file name separated by FORWARD slashes.

  
-SET &YESTERDAY=AYMD(&YYMD,&DAYZ,'I8YYMD');
-SET &FULLFILENAME = '/FOLDER/FILENAME' | &YESTERDAY | '??.CSV';

FILEDEF SYNCFILE DISK "&FULLFILENAME"

This message has been edited. Last edited by: Lloyd,