Re: Declaring datastructure for variable file.. -- RPG400-L

I'm trying to get this to work with Dave and Jon's suggestion of using SQL
(SQLRPGLE).
I'm running into trouble understanding how I should be extracting the DATA
from the DESCRIPTOR. What I currently have is...

// Get a comma separated list of all the columns in the journalled file
columnNbr = BuildColumnList(pJournalFile :columnList);

Exec sql ALLOCATE DESCRIPTOR LOCAL :desc1 WITH MAX :columnNbr;
prepStmtText = 'SELECT ' + columnList +
' FROM ' + pJournalFile +
' WHERE prfrun = ' + prunNumber +
' AND prfrunseq = ' + pSequence;
Exec sql PREPARE prepStmt FROM :prepStmtText;
Exec SQL DESCRIBE prepStmt USING SQL DESCRIPTOR LOCAL :desc1;
Exec sql DECLARE jrnCursor SCROLL CURSOR FOR prepStmt;
Exec sql OPEN jrnCursor;
Exec sql
FETCH FIRST
FROM jrnCursor
INTO SQL DESCRIPTOR :desc1;

For idx = 1 to columnNbr;
Exec sql GET DESCRIPTOR :desc1 VALUE :idx :journalData.colName =
DB2_SYSTEM_COLUMN_NAME,
:journalData.type = TYPE,
:journalData.length = LENGTH,
:journalData.precision =
PRECISION;

Select;
When journalData.type = 4; // Integer
Exec sql GET DESCRIPTOR :desc1 VALUE :idx :intType = DATA;
yajl_addChar('' + journalData.colName + ''
:%Char(intType));
Endsl;
Endfor;

I got this far but I don't know how I should be getting DATA. The
documentation says that the data type of DATA matches the data type
specified by TYPE. For example, if the TYPE = 1 (character) than
CHARACTER(n)
So how would I declare a variable to receive DATA. In the above example I
think I'm handling the INTEGER tyoe correctly but how do I define varaiable
for the other types?

Thanks,
Rob

On Tue, Jul 2, 2019 at 9:13 AM Robert Rogerson <rogersonra@xxxxxxxxx> wrote:

I wish to thank everyone for the suggestions and ideas.
I think I have the datastructure issue resolved. I now define the inFile
globally with a variable for extfile. In the procedure I
close the file
set the variable for the extfile (to override to a specific file)
open the file
I also create a datastructure char(9999) to read into.
As for the columns I am selecting from syscolumns.
So far it's almost working

@Birgitta (my sql heroine) I wish I could use your suggestion but I'm
limited to V7R1.

Again, thanks again for the help and ideas...

Rob

On Tue, Jul 2, 2019 at 1:09 AM Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

If you only want to create JSON from a file, you should use SQL.

Sometimes ago I made some SQL Functions OpenSource
(https://github.com/BirgittaHauser/Generate-XML-and-JSON)
You may have a look on it, may be you can use the SQL functions in your
embedded SQL.
TABLE2JSON converts the content of a table into JSON
SQL2JSON converts the result of a SELECT Statement into JSON

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
„Train people well enough so they can leave, treat them well enough so
they
don't want to.“ (Richard Branson)

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Robert
Rogerson
Sent: Montag, 1. Juli 2019 22:02
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Declaring datastructure for variable file..

@Dave, I'll look into the DESCRIPTORS in sql.
@Charles. The purpose is to create a JSON document where the in the format

{
"FILENAME1 ": [

{"col1": "col1 data"},
{"col2": "col2 data"}
]

}

The challenge is that FILENAME1 is not know until run time.

Any thoughts or admise would be appreciated.

Thanks,

Rob

On Mon, Jul 1, 2019 at 3:20 PM <dlclark@xxxxxxxxxxxxxxxx> wrote:

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> wrote on 07/01/2019
02:26:16 PM:

I'm creating procedure where I want to pass the file name to the
procedure. So my file declaration in the procedure is...
dcl-f infile disk usropn extfile(pFileIn);

Now when I want to read the file as it's in a procedure I must use a

data

structure. How do I define the data structure as the file is
unknown at compile time. I'm thing something like...

dcl-ds inFileDs extname(pFileIn) end-ds; But it gives me
RNF3523: External description INFILEDATA for data structure is not

found;

data structure is ignored.
RNF3608: The parameter for the EXTNAME or EXTFLD keyword must be a
character literal or constant.

How should I be defining this?

If you really want to use "standard" RPG for this type of
access then you would have to create an open data structure (i.e.,
with no
subfields) and parse it out yourself using %substr. But then you
would have to know the file layout ahead of time, too -- or use an API
to get the equivalent of DSPFFD. Alternatively, SQL has DESCRIPTORS
to get the column definitions.

Sincerely,

Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300

Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331

Thanks,

Rob
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post
a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://urldefense.com/v3/__https://lists.midrange.com/
mailman/listinfo/rpg400-l__;!s27icpZD2fbA_A!
MkKppGnwAoTf7X4MUGG87i8PYhG_IraFw330A1_Jm1n66a3RiulJRogUeYLaB7HvXQU$
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://urldefense.com/v3/__https://archive.midrange.com/rpg400-
l__;!s27icpZD2fbA_A!
MkKppGnwAoTf7X4MUGG87i8PYhG_IraFw330A1_Jm1n66a3RiulJRogUeYLacMYGhVM$ .

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

Help support midrange.com by shopping at amazon.com with our
affiliate

link:

https://urldefense.com/v3/__https://amazon.midrange.com__;!
s27icpZD2fbA_A!
MkKppGnwAoTf7X4MUGG87i8PYhG_IraFw330A1_Jm1n66a3RiulJRogUeYLala07x6Q$

**********************************************************************
*********************** This email message and any attachments is for
use only by the named
addressee(s) and may contain confidential, privileged and/or
proprietary information. If you have received this message in error,
please immediately notify the sender and delete and destroy the
message and all copies. All unauthorized direct or indirect use or
disclosure of this message is strictly prohibited. No right to
confidentiality or privilege is waived or lost by any error in

transmission.

**********************************************************************
***********************
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com