Free IT Book: Securing SQL Server by Mrdenny!
This week’s free IT book is especially exciting because it was written by Denny Cherry, who you may know better as mrdenny. He’s always providing quality and thoughtful answers, and we’re excited to share a whole compilation of his knowledge in Securing SQL Server: Protecting Your Database from Attackers. Denny is a Microsoft SQL Server [...]

Answer Question   |  February 21, 2012  8:31 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, SQL Server security, Storage, Virtualization, VoIP, Windows Server

SQL Update Set: Higlight Customers without Invoices, Update and join Tables?
Hello, I am not sure how to do this with an SQL Update Set statemet: I have a table customers and I have related invoices. I would like to set one field to “not active” in the customer table that did not receive invoices since 2008. I can “Select” the corresponding records in the customer table [...]

Answer Question   |  March 28, 2011  2:03 PM
AS/400 DB2, DB2, SQL statement

Purchase order document in JDE environment
Hi, Can anyone tell me where i can find books for Purchase order module in AS400 in JDE environment.

Answer Question   |  March 28, 2011  9:40 AM
AS/400 Purchase Order, JDE, Purchase order

Logging back into AS/400
The question is very simple and I hear a lot of talk about nothing to do with the question asked…Please understand, I am not able to log in to get to the wrksplf or wrkjob queues.  HOW DO YOU GET BACK ON AS400 SYSTEM ONCE YOU’VE LOGGED OUT? While trying to log back on, the [...]

Answer Question   |  May 3, 2011  9:01 PM
AS/400, AS/400 jobs, AS400 - COBOL, WRKSPLF

RPG Net pgm with dataq
Hi. I need some help with net pgm. This is my stuff: 1- ADDPJE SBSD(LIBINO/INOSBS) PGM(LIBINO/TST44R) 2- TST44R read a InoDtaq 3- In WrkActJob I can view the INOSBS with TST44R 3 times (default) 4- I have a pgm TST43R that write a LIBINO/INODTAQ. I run it. 5- I run TST44R and in WorkActJob its [...]

Answer Question   |  March 28, 2011  7:27 PM
AS/400 Parameters, RPG, RPG Program

spoolfileread
how to read spool files in rpg program,i want to read spool file in rpg program

Answer Question   |  March 28, 2011  5:51 PM
AS/400, AS/400 Spool Files, RPG Program, Spool files

Error in cpytoimpf in AS/400 V5R4
Hi all, I am using V5r4 I am getting error while transfer data in QDLS into stream file Error : FILE SYSTEM ERROR OCCURRED.  ERROR NUMBER 3486 CPYTOIMPF FROMFILE(TESTLIB/AMO140F) TOSTMF(‘/QDLS/folder1/folder2/INV20.CSV’) + MBROPT(*REPLACE) STMFCODPAG(*PCASCII) + RCDDLM(*CRLF) FLDDLM(‘,’) DATFMT(*EUR) + TIMFMT(*EUR) This is working fine with dir. but problem is only in QDLS. But i need to [...]

Answer Question   |  March 29, 2011  10:33 AM
AS/400, CLLE, CPYTOIMPF, RPGLE, V5R4

MySql Select multiple columnsfrom distinct rows based on one column
I am building one sql query based on 5 select statements unioned all together. Each select is built as a variable with where clauses based on filters selected by the users. All 5 selects are concatenated together to build the one dynamic query. The one select below needs to be changed to select rows only [...]

Answer Question   |  March 28, 2011  6:35 PM
iSeries V6R1, MySQL, SQL statements, V6R1

Why this error code in COBOL program: CPD7914
Need help getting pass this error message. using this input file definition * Beginning of data *****************************   R DCREFR                                           DCCODE         3          ALIAS(DC_CODE)         DCMEANING     50          ALIAS(DC_MEANING)  Which is called by this DSS file definition:                                         UNIQUE                                                     REF(DCREF)                     R DCPHYR                                                     DCCODE    R                                                DCMEANING R                                              K DCCODE                                        A*     DCPHY                                               A          [...]

Answer Question   |  March 25, 2011  6:00 PM
AS/400 error messages, COBOL, COBOL Programs, COBOL/400

MONMSG
can I use monmsg in an exit in brms to monitor for a CPF3741 MESSAGE

Answer Question   |  March 25, 2011  11:12 PM
AS/400, BRMS, MONMSG

Find AS/400 libraries created
thanks i have an authority to create libraries,my problem is i forget how many libraries create in my user id ,my requirement is find out.how many libraries are there and what are those in my user id

Answer Question   |  March 25, 2011  5:07 PM
AS/400, AS/400 Library, AS/400 Optical Library

AS/400 Scratched System Report
How may I get a report that the AS/400 system was scratched for the Auditors.

Answer Question   |  March 24, 2011  1:48 PM
AS/400 audit, AS/400 Reports, AS/400 system administration

Find user-related list of AS/400 libraries
how to find out one user id related list of libraries in as400 system,not all libraries in system,only one user id related libraries

Answer Question   |  March 23, 2011  11:52 AM
AS/400, AS/400 Library, AS/400 user profiles, AS/400 Userlist

how to print a string in bigger font in report in as400
hi,My question is ,i have a report generated in spool where i want a string (for eg; customer name) in bigger font.Is it possible in as400 (like we do it in ms-word) ? If so how?

Answer Question   |  March 24, 2011  10:05 AM
AS/400 printers, AS/400 printing, AS/400 Spool Files, AS400 printing issue

Declaring the same file twice with two OPENID and reading the same file twice in CL Program
 Is it posssible read a db file while declaring twice with openID     and reading the same file twice

Answer Question   |  March 24, 2011  3:32 AM
AS/400 Database File, CL programming, Database Files

Reading a file in Reverse Order in CL Program
) In CL program how can we read a data base file in reverse order.

Answer Question   |  March 26, 2011  3:28 AM
AS/400 Database File, CL Program, Database Files

how to install Rational Developer for iseries in windows
How do I get Rational Developer install on my PC. We just got a new iseries v7r1 and it is supposed to have all these new tools. I need to learn web facing and do not know how to get started. Or do I need Websphere client installed on PC. Right now I only have [...]

Answer Question   |  March 23, 2011  2:52 AM
IBM i, PC5250 Emulator, Rational Developer for IBM i, Webfacing, WebSphere Studio

AFP printer-driver for Linux (where to get?)
I just moved from WinNT to linux on my ThinkPad. I am now in lack of an APF printerdriver. (I need this driver to help me create printoverlays for my IBM Power System i). With WinNT I used the IBM AFP 300 driver. pls hint me where to find such driver. DanF

Answer Question   |  April 14, 2011  4:26 PM
AS/400 printer drivers, AS400 printing issue, Drivers, Linux, Linux printer drivers, Printer drivers

Java to file system in AS/400
I have a java class that running in as400 application server. I want to read from a excel file in the local pc (C:/abc.xls or //as400sys/approvals/qdls/abcflr/abc.xls) . my java class don’t see my excel file in C:

Answer Question   |  April 15, 2011  4:12 PM
Application servers, AS/400 applications, Java

Ping timeout issue
I have a setup in India, wherein we need to connect to servers in the US to do all our work. For the last few days, I am experiencing a strange problem, and am not able to find the cause. I have a router to router tunnel between my India location and the US location. [...]

Answer Question   |  March 25, 2011  1:53 PM
BSNL, Connection timeout, Network Timeout, Ping Request Timed Out, Router configurations