Default Menu standards
How do I change the default menu layout template that is displayed after taking SDA option #2 to reflect our company standards? In other words; After typing the command "STRSDA 2", the Design Menus prompt screen is displayed requesting a menu source file, library and menu name. Once that...
How do I change the default menu layout template that is displayed after taking SDA option #2 to reflect our company standards? In other words; After typing the command "STRSDA 2", the Design Menus prompt screen is displayed requesting a menu source file, library and menu name. Once that...
270 pts.
SQLCOD = -7008 when doing an insert into file using SQLRPGLE-2
Hi, I'm trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am...
Hi, I'm trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am...
SQLCOD = -7008 when doing an insert into file using SQLRPGLE
Hi, I'm trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am...
Hi, I'm trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am...
Displaying Chinese on 5250 screens
Hello, I need to change some CL driven green-screen menus to display Chinese instead of English. We don't need to change the applications or data behind the menus ... just the menus themselves which are actually driven by message files with a display file and some CLP. Does anyone know of a...
Hello, I need to change some CL driven green-screen menus to display Chinese instead of English. We don't need to change the applications or data behind the menus ... just the menus themselves which are actually driven by message files with a display file and some CLP. Does anyone know of a...
DDS
Is there any way (field attribute, key word, etc.) to keep the beloved end user from not using the field exit key when entering a value in a numeric field ?? We have users who will continually use the tab key or just hit enter when entering a 1 (for example) in a field, thereby creating a value of...
Is there any way (field attribute, key word, etc.) to keep the beloved end user from not using the field exit key when entering a value in a numeric field ?? We have users who will continually use the tab key or just hit enter when entering a 1 (for example) in a field, thereby creating a value of...
Deleted Users
Hi Is there any way we can know about deleted userprofiles in AS400? We have an audit process wherein the auditor have asked for a list of all the users deleted. Can any one suggest where can I get such a list? pgsdeb
Hi Is there any way we can know about deleted userprofiles in AS400? We have an audit process wherein the auditor have asked for a list of all the users deleted. Can any one suggest where can I get such a list? pgsdeb
folders and documents
Is there a way for a program to find out if a folder contains any documents (we will not know a document name). We need to know if the folder is empty or if it contains any documents.
Is there a way for a program to find out if a folder contains any documents (we will not know a document name). We need to know if the folder is empty or if it contains any documents.
Data mapping errors when reading records with time fields...
I'm trying to access records from a file that has eight fields defined with the time attibute. When I examine the data held in these fields they are mostly set to *LOVAL i.e. 00.00.00 in *ISO format which according to the RPGLE reference manual is an allowable value. However, when my program...
I'm trying to access records from a file that has eight fields defined with the time attibute. When I examine the data held in these fields they are mostly set to *LOVAL i.e. 00.00.00 in *ISO format which according to the RPGLE reference manual is an allowable value. However, when my program...
SQL Alias visibility
We have found that creating an SQL alias works for accessing file members in embedded and interactive SQL. But if we create an ALIAS in our live libraries with the intention of keeping it for frequent use, how do we know it exists other than WRKOBJ? It doesn't show up in DSPDBR. And is there...
We have found that creating an SQL alias works for accessing file members in embedded and interactive SQL. But if we create an ALIAS in our live libraries with the intention of keeping it for frequent use, how do we know it exists other than WRKOBJ? It doesn't show up in DSPDBR. And is there...
Writing in a specific output queue in C/400
Dear all, I need one more time your help... Well, I'm starting to learn C/400 programmation and I would like in my program to log all my traces in a specific output queue (not in the standard QPRINT output queue). I found a solution by changing the default output queue and using the simple...
Dear all, I need one more time your help... Well, I'm starting to learn C/400 programmation and I would like in my program to log all my traces in a specific output queue (not in the standard QPRINT output queue). I found a solution by changing the default output queue and using the simple...
Legal size output thru a printfile in a RPG program
how to print legal size output from RPG programs.
how to print legal size output from RPG programs.
Calling CL program fron a C/400 program?
Dear, I'm very new in C/400 developement and I'm facing an issue. I've some CL program that I would like to call in my C/400 program... Well, ok, I can use the function "error=system(...)"... but my CL program as to return me some information. Here is my CL prgram: PGM PARM(&queue &queue_lib...
Dear, I'm very new in C/400 developement and I'm facing an issue. I've some CL program that I would like to call in my C/400 program... Well, ok, I can use the function "error=system(...)"... but my CL program as to return me some information. Here is my CL prgram: PGM PARM(&queue &queue_lib...
Hex representation for position cursor
Does anyone know the hex representation for the display attribute Position Cursor (dspatr(PC))?
Does anyone know the hex representation for the display attribute Position Cursor (dspatr(PC))?
ldap setup
I am wondering if anyone knows how it would work if I used my Domino public address book server as my ldap server?
I am wondering if anyone knows how it would work if I used my Domino public address book server as my ldap server?
Iseries Connect Shared Drives with Windows 2003 Server
I am currently setting up an iSeries 520 at v5r3 which has a number of shared drives, holding data in IFS. I am using RUNRMTCMD to call a batch program on Windows 2003 Server R2 machine. The job starts fine, but the Shares that have been set up then show as disconnected on the 2003 server, as a...
I am currently setting up an iSeries 520 at v5r3 which has a number of shared drives, holding data in IFS. I am using RUNRMTCMD to call a batch program on Windows 2003 Server R2 machine. The job starts fine, but the Shares that have been set up then show as disconnected on the 2003 server, as a...
Get library list in Java
When using the JDBC driver to access files in various databases I would like to use the current library list for the job rather than the user's jod description... i.e. How can I set the library list to use the current library list rather than the user's job description. e.g. So that regardless of...
When using the JDBC driver to access files in various databases I would like to use the current library list for the job rather than the user's jod description... i.e. How can I set the library list to use the current library list rather than the user's job description. e.g. So that regardless of...
trigger programs
I am using a trigger program to call a display pgm if a file has changed. Is this possible? Is there something else I should be using?
I am using a trigger program to call a display pgm if a file has changed. Is this possible? Is there something else I should be using?
Odd RPGLE Multiplication issue
I have a RPGLE program that traverses through a bill of materials to do a cost roll up. Part of the code multiplies several quantities together to get the quantity needed at that level. The multiplication is not yielding the correct answer and I?m not sure why. Below is a small sample program that...
I have a RPGLE program that traverses through a bill of materials to do a cost roll up. Part of the code multiplies several quantities together to get the quantity needed at that level. The multiplication is not yielding the correct answer and I?m not sure why. Below is a small sample program that...
Year in Date or Timestamp value is not in the correct range (C G D F).
Hi All, I am getting the above error when trying to write the control format of a subfile. The DDS is coded as follows: A O_ESD L O 9 70DATFMT(*MDY) A MAPVAL(('01/01/40' *BLANK)) Not too sure what the MAPVAL will do as I dont think it can ever...
Hi All, I am getting the above error when trying to write the control format of a subfile. The DDS is coded as follows: A O_ESD L O 9 70DATFMT(*MDY) A MAPVAL(('01/01/40' *BLANK)) Not too sure what the MAPVAL will do as I dont think it can ever...
svchost.exe
When I was working with win 2000 advanced server, suddenly it became slower and I started checking the running processes using task manager and I found 4 svchost.exe are running and one of them with PID:916 was using 38000K memory. After sometime the server became normal and everything is OK now....
When I was working with win 2000 advanced server, suddenly it became slower and I started checking the running processes using task manager and I found 4 svchost.exe are running and one of them with PID:916 was using 38000K memory. After sometime the server became normal and everything is OK now....
