ISeries SQL

SQLRPGLE

I need to retrieve the RRN and use it within my RPGLE program. I have the Select RRN(file) statement, but I get a Character in Cast argument not valid when executing. Any suggestions? Software/Hardware used: iSeries RPGLE

Need to know the date and time a particular sql command was fired through an interactive session

Is it possible to find the date and time a particular sql command was entered. Iam able to view the commands entered in an sql session but not able to find the date and time the commands where fired.

Retreiving AS/400 SQL scripts

When I start sql on our iSeries, the system returns my previous scripts I have run. Which fle do these live in in the iSeries and can I report on them? Software/Hardware used: i570

AS/400 SQL

want to all some users to run an SQL for display only and not allow update of delete. is there a way to do this

Iseries SQL Auditing

I want to audit interactive SQL statements. Is this something I can do and if so how ?

COPY data between to files with SQL in iSeries

hi, i need help with this: i have two files in Iseries one of them is new and other have old records and i pretend with sql copy some records. But file 1(new) and file 2(old) they don't have same collums file1 file2 fielda fielda fieldb fieldb fieldc filedd fieldd how can i...

Need an iSeries SQL that will reduce mutilple entries to one per type

I need to produce an extract that is a combination of two files. File A has a policy number and a folder type. File B has the document number. File C will be the product of File A and File B. I can join the files on the policy number and folder type to get the document number, however, I need...