iSeries SQL case on AS/400
Is there an equivalent to case when exists on the as/400?

Answer Question   |  June 23, 2011  10:14 AM
AS/400 SQL, DB2 SQL, iSeries, iSeries SQL

Can you use variables as input and output when calling a stored procedure in COBOL?
If you move data into your variable before calling your procedure, can the procedure then return a value back, which might be different? The procedure will intially be searching for the variable data, but, according to our .net programmer, will return a blank or null if it does not find the data. So far, that [...]

Answer Question   |  June 27, 2011  5:02 PM
CL variables, COBOL, SQL procedure, SQL variables, Variable fields

CL Journal Checking Program (AS400)
I would need help to write a CL program that accepts fields: a) From Time b) To Time c) From Date (This should be able to be *CURRENT) d) To Date (This should be able to be *CURRENT) I want to only select updates/deletes/changes to files (i.e. no I/O type access etc) Please suggest.   [...]

Answer Question   |  June 23, 2011  3:42 PM
AS/400 journaling, CL programming, CL programs, Journal Program

Mail Journaling Issue in Lotus Domino
I have enabled mail journalling on two servers in our environment. Now every message which is sent to an id where some forwarding rule is enabled, the message is being journaled more than one time. I think this is happening because those rule are forwarding the mail arriving on that id to many other users [...]

Answer Question   |  June 23, 2011  2:17 PM
Journaling, Lotus Domino, Lotus Domino Server 8.x

AS/400 Query Job Log
Dear all, Its my first time I submit a question so, please forgive me if I do something wrong. My question is if it possible to have a detail job log from a query. I mean if I can see what files I have used or what criteria I have used. Thank you Lambros

Answer Question   |  June 23, 2011  1:02 PM
AS/400 job logs, AS/400 Job Queue, AS/400 jobs, AS/400 Query

Configure SSL on iSeries
[em]-configure SSH on the AS400 [/em] [em]-connect via a VPN from the desktop of a PC for a Client Access green screen session.  [/em] [em]Ian, they will probably want to connect 400 to 400, so as to transfer compiled objects across ie no source code for ‘restricted’ modules (only a guess). They could use FTP [...]

Answer Question   |  June 22, 2011  12:54 PM
AS/400 Configuration, iSeries, SSL

BRMS reporting damaged objects after a backup
When BRMS encounters a damaged object, it skips the remaing libraries and goes to the DLO.  Where in BRMS can you check to see what libraries have been skipped?

Answer Question   |  July 1, 2011  8:37 PM
AS/400, AS/400 backup, BRMS, BRMS Backup

Free IT Book: Securing SQL Server
This week’s free IT book is written by one of IT Knowledge Exchange’s very own members, Mrdenny. Securing SQL Server promises to help you “secure your SQL Server database so the outside world can’t access your internal data.” With Mrdenny’s extended experience in simplifying SQL speak via his blog, SQL Server with Mr. Denny, this [...]

Answer Question   |  June 24, 2011  7:56 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Open IT Forum: Are you on hacking offense or defense?
Sony isn”t the only company getting hit hard by hackers. Sega just joined the bunch, and Lockheed Martin’s breach is still fresh. How does your company set up a strong offense against hacks and breaches? Or, if your company’s security has been compromised in the past, how did you respond and set up a sufficient [...]

Answer Question   |  June 29, 2011  7:52 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, Sony, Sony PlayStation Network breach, SQL Server, Storage, Virtualization, VoIP, Windows Server

RPGLE Embedded SQL Not null
RPGLE Embedded SQL is getting a SQL0305 (SQLcid-305, sqlstate 22002) when fetching the next record from a view.  This is pointing to null values encountered.  /free                                                   exec sql                                                fetch next from C1 into :wtclaims                  ;  /end-free                                          Wtclaims is an Externally Described Data structure. There could be null values in any field in the ds over [...]

Answer Question   |  June 24, 2011  3:33 PM
AS/400, Embedded SQL, RPGLE, SQL

Printing Electronic Signature that is Printer Resident
HELP!!!   I am trying to print an electronic signature that is printer resident on an HP printer attached trough the LAN.  I have the PCL Escape sequence from the manufacturer.  So far, I have retrieved the WSCST source, modified it to include an INDFNTE tage with a unique font id (used to passs the PCL [...]

Answer Question   |  June 24, 2011  2:47 PM
AFPDS, AS/400 - DDS, AS/400 printing, DDS, iSeries V6R1

HDDs protected or unprotected?
Hello, After upgrading an existing 8203-E4A machine (i5/OS, V5R4M5) with 2×139 HDDs feature code #3677, i see in the “Work with disk units-> Display Disk Configuration Protection” that the model of disk units added are 090. The array is RAID5 and have 6 HDDs. 3 HDDs are 099, 2 HDDs are 090 and 1 is [...]

Answer Question   |  June 21, 2011  2:33 PM
AS/400 hardware, AS/400 storage, HDD, i5/OS

Need to use the cpytoimpf command but have problem
I have an existing process that uses the following command the only change was to have it use the tildes (~) as a field delimiter. CPYTOIMPF FROMFILE(*LIBL/BDPRISM) TOSTMF(‘/home/attach/vhaeom2/vhasales.txt’) MBROPT(*REPLACE) STMFCODPAG(1252) RCDDLM(*CRLF) DTAFMT(*FIXED) STRDLM(*NONE) FLDDLM(‘~’) But the command the command execute without error but the tilde is not place between the fields.  Below is a small [...]

Answer Question   |  June 20, 2011  6:55 PM
CL Commands, CPYTOIMPF, iSeries Commands

How to Monitor File Changes done thru STRSQL
I need a solution for monitoring file changes done by programmers using the STRSQL from a command line for SOX purposes.

Answer Question   |  June 20, 2011  6:44 PM
AS/400 administration, AS/400 SOX, Command line, SOX, STRSQL

AS/400 Authorization Lists
I created a AUTL with only Read access to certain files.  When my user ran an SQL statement against one of the files in the AUTL that he is a member of it said that he did not have authority to the file.  Why would this not work?

Answer Question   |  June 20, 2011  4:47 PM
AS/400, AS/400 Authorization List, AS/400 database, AUTL

Wanna see IP or device name in OS/400?
How can I see the device name or IP address of a person who disabled user profile by hitting wrong passwords in OS400 environment?

Answer Question   |  June 22, 2011  2:34 PM
AS/400, AS/400 user profiles, IP address, OS/400

SAP on iseries or SAP on AIX
We are planning to buy SAP ERP for our Insurance company. Which OS would be desirable to give the best out output both in terms of performance and economy.

Answer Question   |  July 1, 2011  12:30 PM
AIX, AS/400, iSeries, SAP

PRTFIL description
how to find a field? I have to change a fonction. I have an error: screen is to large but i can not find where is the problem. It is a fonction PRTFIL, large 198 and all the fields i can see are less than 198. Perhaps there is a field (blank,constant) anywhrere but where? [...]

Answer Question   |  June 29, 2011  12:09 PM
AS/400, AS/400 Printer File, AS/400 printers, Printer files

How to get the file name in RPG when file error/exception occured
My program processes bulk of file updates, and I’m trying to figure out the file name that was failed in processing. However the limitation for INFDS is, we cannot use the same DS name for all the files declared in a program. And it’s hectic to declare unique DS for each INFDS. Is there any [...]

Answer Question   |  June 15, 2012  8:49 AM
AS/400, INFDS, iSeries, RPF

How to use API’s?
I’m trying to use the regular expressions API’s REGCOMP(), REGEXEC(), and REGFREE(). My text says handle them like a procedure, article seems missing info. Error examples are Prototyped call can’t be used in an expression because it doesn’t return a value, Types/Attributes of parm don’t match the prototype, Parameter can’t be passed by reference, etc. [...]

Answer Question   |  June 20, 2011  6:46 PM
API, REGCOMP, REGEXEC, REGFREE, RPGLE