Re: Display SELECT results to green screen

To leapfrog a bit - when you get the value for a column, then it is ***just the same as any variable in RPG*** - in this case, tableName could be a DSPF variable - once populated, WRITE to a subfile and EXFMT.

Or use any other method of presenting information - send a message that will display using the contents of the field. Or as Buck has it, use a PRTF. EXCEPT (heh) I would use an external one, probably.

HTH
Vern

On 3/25/2015 3:29 PM, Buck Calabro wrote:

On 3/25/2015 3:54 PM, Barb Hines wrote:

I am using Scott Klements' JDBCR4 freeware, and attempting to access an SQL table and return the results to a green screen display. I can connect without issue.
I'm sure this must be a very simple thing to do, but I'm unable to get display results.

Does anyone have a program example they would be willing to share?

I have an RPG example:

// Prepare SQL statement string
prepstm = JDBC_prepStmt(conn:
'SELECT * FROM information_schema.columns order by table_name');

if (prepstm = *NULL);
jdbc_close(conn);
return;
endif;

// Query the database
rs = jdbc_ExecPrepQry(prepstm);

dow (jdbc_nextRow(rs));
tableName = jdbc_getColByName(rs: 'table_name': nullInd);
if nullind = *on;
tableName = 'NULL';
endif;
...
except prtRow;
enddo;

JDBC_FreeResult(rs);
JDBC_FreePrepStmt(prepstm);
JDBC_Close(conn);

You might find more people using this over in the RPG list.