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.

Answer Question   |  December 10, 2009  4:30 PM
Application development, AS/400, CLP, RPGLE

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 attempts to read [...]

Answer Question   |  November 22, 2010  9:51 AM
Application development, DB2 Universal Database, RPGLE

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 [...]

Answer Question   |  June 23, 2006  4:17 PM
Application development, DB2 Universal Database, SQL

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 printf… [...]

Answer Question   |  June 21, 2006  6:19 AM
Application development, AS/400, CLP, Printing

Legal size output thru a printfile in a RPG program
how to print legal size output from RPG programs.

Answer Question   |  June 14, 2006  12:51 PM
Application development, Printing, RPGLE

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 &sens) DCL &queue [...]

Answer Question   |  November 21, 2010  6:30 AM
Application development, AS/400, CLP, Web development

Hex representation for position cursor
Does anyone know the hex representation for the display attribute Position Cursor (dspatr(PC))?

Answer Question   |  December 8, 2009  9:04 AM
Application development, AS/400, RPGLE

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?

Answer Question   |  June 7, 2006  12:19 PM
Application development, AS/400, Lotus Domino, Platform Issues

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 [...]

Answer Question   |  December 8, 2009  7:23 AM
Application development, AS/400, DataCenter, Interoperability, PC/Windows Connectivity, Software

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 whether [...]

Answer Question   |  November 21, 2010  3:38 AM
Application development, AS/400

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?

Answer Question   |  May 31, 2006  10:20 AM
Application development

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 illustrates [...]

Answer Question   |  December 8, 2009  12:09 PM
Application development, RPGLE

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 be blank. Basically in the compile listing [...]

Answer Question   |  June 2, 2006  3:20 PM
Application development, AS/400, CLP, DB2 Universal Database, RPG, RPGLE

Performance issue
Hi I am using an OPNQRYF in a program which is used quite frequently. Now, the program takes about 20 secs when called once. I tried to create some logicals which can expedite the access to files but there has not been any appreciable change in the performance. Can anyone suggest any other method which [...]

Answer Question   |  December 7, 2009  10:47 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development

compile commands in RPG
hey all! i am working on a project where i have to use compile commands for various member types, such as CRTRPGPGM for RPG, CRTPF for PF and so on.. but these commands have to run in the background, and the user should know nothing of it, i.e. it should be program oriented. how can [...]

Answer Question   |  December 7, 2009  2:40 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development

command execution
thanks a lot!! for the help… but meanwhile i have got another problem…in my project- i have to use COMPILE commands such as CRTPF, CRTCLPPGM, CRTRPGPGM and so on…in a program and this has to be transparent to the user. in CL these programs cannot be used… how can i do this? plz help me [...]

Answer Question   |  November 21, 2010  4:04 AM
Application development, AS/400, CLP, RPG

Program Status Data Structure
Hi All, For position 191 – 198 in the SDS, is this always the Date the Job Entered the system? For example, we have a CL that starts at 23:50 on say 5/10, it does some processing and on the way out it calls an RPG at say 0:35 on 5/11. Will the date in [...]

Answer Question   |  December 7, 2009  1:54 PM
Application development, AS/400, CLP, RPG, RPGLE

souce file listing
hi all! i wanna know how can i retrieve the names of the components of a Source Physical File i.e. the names of the souce code (members) within a particular Source Physical File…i want ot retrieve the names and store in a database file and later use them for subfile operations. kindly help me out!!!!!! [...]

Answer Question   |  December 7, 2009  8:15 AM
Application development, AS/400, CLP, DB2 Universal Database, RPG, RPGLE

Web (HTML) command prompting utilizing the QCDRCMDD output
I would like to prompt OS/400 commands on the web using HTML (or any other web tool). I assume the best way to do it is by generating the XML file using the QCDRCMDD (Retrieve Command Definition) API and utilizing it using some kind of prompting tool. I know how to generate the XML file. [...]

Answer Question   |  May 18, 2006  10:07 AM
Application development, Development, Web development, Web development tools

Communication between 2 AS/400s
We have the Softlanding product Turnover to do our change management. Our development machine is in a different building and we distribute our software using that tool via FTP. From development to production machine we use a VPN tunnel (note this is controlled by network people). The software uses the ftp code of ‘Quote RCMD [...]

Answer Question   |  May 5, 2006  8:51 AM
Application development, Firewalls, Forensics, Incident response, Intrusion management, Network management software, Network security, TCP, VPN, Wireless