How would we know which index is been used during Native IO reads or SQL query execution happens on that file during program is being run?

For example on an as/400 Data base file, some 10 indexes are created? How would we know which index is been used during Native IO reads or SQL query execution happens on that file during program is being run?

TNKR130 pointsBadges:

Update done in physical file which does not reflect in Logical file

Hello All,   1.I need to know when an update happens to Physical file the updates should not reflect in the corresponding logical file. Please let me know what needs to be done for this.  2. How will we update a field in a physical nd not the whole record in RPG IV. Please explain with an...

Ponsasikumar5 pointsBadges:

Prevent record lock scenario with AS/400 ?

Suppose 2 users are accesssing the same record in a file.User 1 tried to update the record and while doing so he did not log-off from his update screen,while the user tries to do inquiry on that same record. As a result there will be a record lock situation.How to prevent this scenario ? i need...

Supriyoas400250 pointsBadges:

using %char and removing leading blanks

I have a 6 pos serial number, ex(000022) that I need to CAT onto a qualifier of UN. so the final result should be UN22. I would like to do this using %char. I thought I could do it in one line, but I am having issues with not being able to remove the leading blanks. My result ends up being...

Dobie80 pointsBadges:

I need help with DSPF…

Hi everybody, i try explain my need. I have one RPG pgm with several DSPF, and for this work well, i have a OVRDSPF. My problem is when other people make any changes in one DSPF we have a level check, i know that, but because of this i need a idea for make an ALERT inside of DSPF source code in...

BUG68235 pointsBadges:

How can I list users who accese DB2/400 via ODBC or data transfer of iSeriesAccess

We have many users who access DB2/400 database via ODBC or data transfer of iSeriesAccess. Are there any way to list those users from the accounting journal or audit journal?

ISHII5 pointsBadges:

Isolation level in iseries DB2

How to set isolation level in iseries DB2? please reply.

ORS5 pointsBadges:

Difference between RPGIII RPG IV and RPGLE

1)Can some one tell me the major differences between them? 2)Subprocedures, Built in func etc stuff does come under RPGIV or RPGLE? 3) I beleive Actiation groups, static Binding, modules, Service pgms.. does come under RPGLE? please explain me a bit clear, and it would be thankful if you have...

Kar425 pointsBadges:

upload a pc file to as/400 iseries

i wnat to upload a pc file of length 311 with 25 fields to iseries. I followed the steps specified in waltz400 on july 13th 2005.But i got a messags saying "CWBTF0005-data in this field incorrect(row1,colomn1)or does not match the pc data type" . sINCE THE FILE SIZE IS BIGGER I COULDN'T SAVE IT AS...

Pc196425 pointsBadges:

Restoring Files

Dear All, I want to set up a new test enviornment in our development box. A sub system has already been created. The following needs to be done. 1. Restore all physical files from PRDFLIB TO DEVFLIB 2. Restore all logicals from PRDLLIB to DEVLLIB .  The access path of the logicals(devllib) which...

Knowledgeseekerone30 pointsBadges:

AS/400 FTP

How to transfer the file to host using FTP Commands. I am connecting AS400 through CITRIX

rajeshece1,230 pointsBadges:

QMF issue

I have my QMF for windows version 8.1 Fix Pack 13, and I try to run this instruction INSERT INTO destination table SELECT * FROM origin table and every time I receive this error message: An error occurred while running the query. destrination table not valid for operation. (SQL code = -7008, SQL...

Tiburonblanco80 pointsBadges:

How to check existance of record without using file opcodes

By using INFDS and standard fields *FILE/*RECORD.... how to find out a record existance in Physical File without using any file opcode? Please tell me the RPG code how to use it, not only the I spec definition.

Kar425 pointsBadges:

DB2 indexes and Crystal Reports

Is it possible to access DB2 (V5R1) indexes from the Visual Linking Expert screen in Crystal Reports(8) and if so how?

AJ525 pointsBadges:

Delete OLD files from Table not having date or timestamp

Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn't have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn't have creation date field. So, like RRN does DB2 have any...

RJES45 pointsBadges:

how to block update command when using STRSQL ( db2/400)?

Hi People , I got several analysts that they must only use Select command through STRSQL prompt, I found I can block update command changing the object authority but I have loads and load of tables to change, is there any easier way to do that?

Altino20 pointsBadges:

Error code 10: Function sequence error using CPYTOIMPF on AS/400

I am using the CPYTOIMPF function on an AS400 to copy from one data base file to another. I want to end up with a .CSV file format. It worked once but now I get the following error: Message Id: SQ999999 Error occurred in SQL Call Level Interface. A procedure call encountered an error. The error...

AS400 - Ask the Expert485 pointsBadges:

SQL script output to a file

I am running ad hoc SQL scripts in iSeries Navigator (V5R4) and need to direct the output to a text file. Is there a way to do this? TIA... Steve B

SBatSI415 pointsBadges:

Moving data from iSeries to DB2 on Windows

I need to get data from a iSeries DB2 system to my Windows DB2 system. The DBA produced and sent me a savf file. How can I important that savf file into DB2?

Claudek75 pointsBadges:

Giving Permission

Hi, I am studing databases in a iSeries. All my objects are in librarie called DB1_T2. I need to give access to the professor so he can read all my data and execute my functions. How can I do that via the command line. Thanks a lot.

Lv2eof5 pointsBadges: