-
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?
Last updated: -
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...
Last updated: -
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...
Last updated: -
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...
Last updated: -
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...
Last updated: -
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?
Last updated: -
Isolation level in iseries DB2
How to set isolation level in iseries DB2? please reply.
Last updated: -
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...
Last updated: -
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...
Last updated: -
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...
Last updated: -
How to transfer the file to host using FTP Commands. I am connecting AS400 through CITRIX
Last updated: -
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...
Last updated: -
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.
Last updated: -
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?
Last updated: -
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...
Last updated: -
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?
Last updated: -
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...
Last updated: -
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
Last updated: -
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?
Last updated: -
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.
Last updated: