Releasing lock in AS/400
how to find which record is locked and who locked that record.how to release the lock by ourselves.please explain in detail.i’m new to as/400.
Answer Question
| June 22, 2010 2:59 PM
AS/400, AS/400 administration, AS/400 DB2, AS/400 Locking
how to find which record is locked and who locked that record.how to release the lock by ourselves.please explain in detail.i’m new to as/400.
Answer Question
| June 22, 2010 2:59 PM
AS/400, AS/400 administration, AS/400 DB2, AS/400 Locking
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 [...]
Answer Question
| June 14, 2010 7:13 AM
AS/400 DB2, AS/400 Locking, AS/400 Records, Record lock
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 [...]
Answer Question
| June 14, 2010 7:13 AM
AS/400 DB2, AS/400 Locking, AS/400 Records, Record lock
create xml content from as/400 db2
Hi, wonder if these xml functions (XML2CLOB, XMLELEMENT, XMLATTRIBUTES, XMLAGG, …) can be used in db/400 — as/400 V6R1M0, if yes, any sample code? of not what else I can use to generate xml content from db2 queries? Any answer is appreciated.
Answer Question
| November 3, 2010 3:45 PM
AS/400 DB2, DB/400, XML
Hi, wonder if these xml functions (XML2CLOB, XMLELEMENT, XMLATTRIBUTES, XMLAGG, …) can be used in db/400 — as/400 V6R1M0, if yes, any sample code? of not what else I can use to generate xml content from db2 queries? Any answer is appreciated.
Answer Question
| November 3, 2010 3:45 PM
AS/400 DB2, DB/400, XML
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 [...]
Answer Question
| May 5, 2010 8:29 PM
AS/400 DB2, bif
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 [...]
Answer Question
| May 5, 2010 8:29 PM
AS/400 DB2, bif
DB2 data over web browser
Our solutions resides in System i and its all are internal developed systems. Our applications are Logistics business driven and now we have the need to publish these informations over web for view by customers. HOW do i do that.. and what should i consider..
Answer Question
| May 5, 2010 2:55 AM
AS/400 DB2, DB2, System i
Our solutions resides in System i and its all are internal developed systems. Our applications are Logistics business driven and now we have the need to publish these informations over web for view by customers. HOW do i do that.. and what should i consider..
Answer Question
| May 5, 2010 2:55 AM
AS/400 DB2, DB2, System i
Connecting to morethan one AS400 DB2 Remote Databases using SQLRPGLE
I have requirement to connect more than one AS400 DB2 remote/distributed database to retrieve the Quantity by using SQLRPGLE Program. Found working with one remote DB, Retrieving the quantity & other Remote DB is getting connected, but while executing the SQL query it says SQL Package not found. The SQL Package is already available, Could [...]
Answer Question
| April 26, 2010 1:55 PM
AS/400, AS/400 DB2
I have requirement to connect more than one AS400 DB2 remote/distributed database to retrieve the Quantity by using SQLRPGLE Program. Found working with one remote DB, Retrieving the quantity & other Remote DB is getting connected, but while executing the SQL query it says SQL Package not found. The SQL Package is already available, Could [...]
Answer Question
| April 26, 2010 1:55 PM
AS/400, AS/400 DB2
controlling C D I R options in the workstation message queue.
Hello All, Could youplease tell me how to control the C D I R options via programs. I mean that i do not want R to appear in screen and the functionality is automatically done . Can it be possible. If yes please tell in detail and if not then what is the reason.
Answer Question
| March 16, 2010 4:04 PM
AS/400 DB2
Hello All, Could youplease tell me how to control the C D I R options via programs. I mean that i do not want R to appear in screen and the functionality is automatically done . Can it be possible. If yes please tell in detail and if not then what is the reason.
Answer Question
| March 16, 2010 4:04 PM
AS/400 DB2
AS400 – Logical File
I am creating logical file with out any key fields. Here both logical file and physical file do not have any key fields. How will be the access path built here?
Answer Question
| March 15, 2010 6:48 AM
AS/400 DB2
I am creating logical file with out any key fields. Here both logical file and physical file do not have any key fields. How will be the access path built here?
Answer Question
| March 15, 2010 6:48 AM
AS/400 DB2
Isolation level in iseries DB2
How to set isolation level in iseries DB2? please reply.
Answer Question
| February 11, 2010 4:44 AM
AS/400 DB2, DB2
How to set isolation level in iseries DB2? please reply.
Answer Question
| February 11, 2010 4:44 AM
AS/400 DB2, DB2
Calling a URL length more than 200 from CLP
Hi Techies, I would like to call a URL by passing some input values and retrieve some values from the results. 1. The URL lenght is more than 200, with special characters like % ” < / > 2.I need to retrieve values from the particular website. Can u please help me out soon, its [...]
Answer Question
| February 8, 2010 12:31 PM
AS/400 DB2, CLP, CLPROGRAM, DB2, RPG
Hi Techies, I would like to call a URL by passing some input values and retrieve some values from the results. 1. The URL lenght is more than 200, with special characters like % ” < / > 2.I need to retrieve values from the particular website. Can u please help me out soon, its [...]
Answer Question
| February 8, 2010 12:31 PM
AS/400 DB2, CLP, CLPROGRAM, DB2, RPG
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 [...]
Answer Question
| February 2, 2010 5:37 AM
AS/400 DB2
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 [...]
Answer Question
| February 2, 2010 5:37 AM
AS/400 DB2
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 i create must [...]
Answer Question
| December 29, 2009 11:34 PM
AS/400 backup and recovery, AS/400 DB2
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 i create must [...]
Answer Question
| December 29, 2009 11:34 PM
AS/400 backup and recovery, AS/400 DB2
AS/400 FTP
How to transfer the file to host using FTP Commands. I am connecting AS400 through CITRIX
Answer Question
| December 8, 2009 12:52 PM
AS/400 DB2, AS/400 FTP, Citrix
How to transfer the file to host using FTP Commands. I am connecting AS400 through CITRIX
Answer Question
| December 8, 2009 12:52 PM
AS/400 DB2, AS/400 FTP, Citrix
CPF9999
What CPF9999 does?
Answer Question
| March 28, 2011 2:28 PM
AS/400 commands, AS/400 DB2, filtering
What CPF9999 does?
Answer Question
| March 28, 2011 2:28 PM
AS/400 commands, AS/400 DB2, filtering
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?
Answer Question
| July 24, 2009 4:46 PM
AS/400, AS/400 DB2, DB2, STRSQL
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?
Answer Question
| July 24, 2009 4:46 PM
AS/400, AS/400 DB2, DB2, STRSQL
db2/400
I need add a field in existing Physical file without imacting any thing file? i know CHGPF command but i am not sure about which parameter needs to be update… Please advice…
Answer Question
| March 6, 2009 1:15 PM
AS/400 DB2, CHGPF, DB2, Physical File
I need add a field in existing Physical file without imacting any thing file? i know CHGPF command but i am not sure about which parameter needs to be update… Please advice…
Answer Question
| March 6, 2009 1:15 PM
AS/400 DB2, CHGPF, DB2, Physical File
How to retreive stored procedure from DB2/400
How to retrieve the stored procedure body from db2/as400. for example : I created a Stored Procedure as create procedure botest/spload … …
Answer Question
| May 9, 2012 9:34 AM
AS/400 DB2, AS/400 development, DB2 stored procedures, DB2/400
How to retrieve the stored procedure body from db2/as400. for example : I created a Stored Procedure as create procedure botest/spload … …
Answer Question
| May 9, 2012 9:34 AM
AS/400 DB2, AS/400 development, DB2 stored procedures, DB2/400
DB2/400
WHEN ACCESS PATH WILL BE CREATED AND WHEN OPEN DATA PATH WILL BE CREATED?
Answer Question
| January 31, 2011 6:06 PM
AS/400 database, AS/400 DB2, DB2/400
WHEN ACCESS PATH WILL BE CREATED AND WHEN OPEN DATA PATH WILL BE CREATED?
Answer Question
| January 31, 2011 6:06 PM
AS/400 database, AS/400 DB2, DB2/400
record locking in As/400
HI can anybody tell me about how to handle the Record locking situation when more than one user tries to access the same record in a physical file….?
Answer Question
| October 6, 2011 4:02 PM
AS/400 DB2
HI can anybody tell me about how to handle the Record locking situation when more than one user tries to access the same record in a physical file….?
Answer Question
| October 6, 2011 4:02 PM
AS/400 DB2
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 [...]
Answer Question
| December 22, 2008 4:17 PM
AS/400 DB2, AS/400 error messages, CPYTOIMPF, SQL
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 [...]
Answer Question
| December 22, 2008 4:17 PM
AS/400 DB2, AS/400 error messages, CPYTOIMPF, SQL
