Extracting in SQL Server 2005
IS THERE ANY WAY TO EXTRACT FROM A FIED EXAMPLE: I HAVE A ADDRESS LINE AS 1065 VALLEY LANE APT 120                                                       SCHAUMBURG                                                        IL 60195 I NEED TO EXTRACT APT 120  INTO ANOTHER LINE LIKE APT 120                                                                      1065 VALLEY LANE                                                                       SCHAUMBURG                                                                        IL 60195

Answer Question   |  October 27, 2010  1:17 PM
EXTRACT, Field-Level keywords, SQL 2005, SQL 2005 Database, SQL Server 2005

Key Mapping Error when writing records in AS/400
When i try to write to record, i am getting Key Mapping error.Please let me know if somebody has faced this type of error

Answer Question   |  October 31, 2010  1:03 PM
AS/400, AS/400 error messages, AS/400 errors, AS/400 Records

RPG and Service Programs
I’m getting into the “MVC pattern” experience of RPG programming, thanks to Scott Klement’s hints (see “A pattern for reusable code” on his site http://www.scottklement.com and “Binder Language and the Signature Debate” at http://systeminetwork.com/print/64029). After some initial difficulties, I have made an application based on a collection of procedures in a service program (SP) and [...]

Answer Question   |  October 29, 2010  10:44 AM
AS/400, MVC pattern, OS/400, Service program, V5R4

OVRPRTF AND OVRDSPF
Hi,   Please give me real senario where we can use ovrprtf and ovrdspf?   In priterfile why we use ovrprtf ? thanks vg

Answer Question   |  October 27, 2010  6:47 AM
OVRDSPF, OVRPRTF, Printer files, RPG/400

Retrieving Last 7 days Details in AS/400
I’ve a senario, In that i need to extract last 7 days details using query in AS/400. I tried with MAX function. In that it takes MAX(&CURNTDATE) as whole number and subtract. For example i’m subtracting 7 from today’s date (1101027 – 7), i got 1101020. If i subtract 40 means i got 1100987. Can [...]

Answer Question   |  November 1, 2010  6:30 AM
AS/400 Function Logic, AS/400 Query, MAX

Need a Sample of Logical Network Design
I need a sample of logical network design including the access layer, distribution layer and core layer for the following issues – A. The first option is to produce software that the clients can download on their computers to run. The tool will carry out the processing on the clients’ computers and would occasionally need [...]

Answer Question   |  February 16, 2011  6:28 AM
Client Access, Logical Network Design, Networking, WLAN, WLAN access points

Excel 2007 what is the command for scrolling down your rows with still seeing the header row at the top
I know this is so simple but what is the command for scrolling down through rows in Excel 2007 but still keeping the header (titles of the columns) in view. thanks so much!

Answer Question   |  October 29, 2010  3:32 AM
COMMANDS, Excel 2007, Excel 2007 functions

Examples of OVRDBF in CLLE
sir  i am learninig about as/400 .but i dont have clarity about ovrdbf topic clle plz give some examples about ovrdbf in cl  with clarity

Answer Question   |  October 28, 2010  12:39 AM
AS/400, CLLE, OVRDBF, V5R3

Why is this OUTQ missing the IP Address Field?
Why when I go to WRKOUTQ on the Printer i dod not see the Internet Address Feild as I do on my other Printers OUTQ?

Answer Question   |  October 28, 2010  5:09 PM
AS400 printing issue, IP address, iSeries printer output, OUTQ, OUTQ management

Can there be more than 1 MSGSFL per RPG/400 display file?
I am trying to use more than one MSGSFL for one display file.  One is for a WINDOW (which works).  I then added one for the initial screen.  When I go to initially write it (WRITEMSGCT1) I get a permanent I/O error.  Is it possible to have more than on MSGSFL per display file? See [...]

Answer Question   |  October 26, 2010  5:07 PM
Display File, iSeries, MSGSFL, RPG/400

Issue in PDF Converter in As400 for Czech Language
I am using CVT2CMD command which I have downloaded from internet and this is for conversion of as400 spool to PDF. I am facing an issue for czech language. Please find the below font and encoding details, /Type /Font             /Subtype /Type1         /Name /F1               /BaseFont /Courier      /Encoding /WinAnsiEncoding

Answer Question   |  December 13, 2010  1:52 PM
AS/400 PDF, AS/400 Spool Files, Encoding Issue, PDF conversion

How do I read a File to end active jobs within my CLP?
First I would like to say thanks to Tom for always helping. Info: I performed a wrkactjob job(joblog*) and created a spool file based on the results, then I copied that to a pf file call myfile (all within a CLP). I would like to end the jobs that show up in myfile, but im [...]

Answer Question   |  October 27, 2010  10:22 AM
AS/400 jobs, AS/400 Library, CLP, Job Control Language, WRKACTJOB

Migrate Oracle 9i to Oracle 10g
kindly provide me with details steps, as i will upgrade over 50 servers. what i am doing in three sites: 1) build temp server with same version. 2) uninstall Application. 3) uninstall 9i. 4) dis-join domain. 5) install Oracle 10g. 6) join domain mandatory for my application. 7) install my application. 8) imp sys/XXX@XXX file=xx.dmp [...]

Answer Question   |  November 8, 2010  5:04 AM
EXP dump files, IMP, Memory dump files, Oracle 10g, Oracle 9i, Oracle 9i migration, Oracle upgrades, Windows Server 2003

Runtime error and compile time error in RPG/400
Hi,   Can you please give me real senerio what is mean by runtime error and compile time error?please give me the logic of both?

Answer Question   |  October 28, 2010  4:57 AM
AS/400 compile, AS/400 Runtime Errors, RPG/400, Runtime Errors

AS400 Time Zone changes
Where do i see the date and time that my time will be changed

Answer Question   |  October 28, 2010  6:06 PM
AS/400, AS/400 date format, AS/400 TimeStamp, AS400 Daylight Savings Time

Sending iSeries spool files to a network printer
I have a problem whereby my network printer is printing multiple copies of a spool file I have sent to it – it just keeps churning them out. The printer in question is an OCE’ re-branded multi-function printer. I believe it’s a VL2822C VarioPrint machine. Has anyone used these to print from an iSeries system? [...]

Answer Question   |  November 1, 2010  6:35 AM
iSeries networking, iSeries printer output, iSeries printing, Network printing, Print Spool File, V5R4

TCP/IP limits on routers/switches
Does anyone know if there are limits using a router/switch or separate routers and switches for the number of users online (not twinax local terminals but remote terminals) concurrently? I know multiplexers on mainframes would allow modems to allow many terminals at one time…and the terminalID would be included with data stream for each respective [...]

Answer Question   |  February 16, 2011  2:28 PM
AS/400, Routers, Switches, TCP/IP CONNECTION, TCP/IP terminal limits

Map spool file data to overlay
Please excuse the length of the post but I am new here and not quite sure how to get across what I need. We have a spool file that we do not have source for, it’s from our financial application and cannot be changed. I need to take data from that spool file and place [...]

Answer Question   |  February 16, 2011  12:51 AM
map spool data, OS/400, Spool files, V5R4

CPYSPLF To database fails with message CPF3468
Hello there: I’m having problems at work for the last couple days. I submitted a job that wakes up when the Dataque retrieves an incoming spool file (invoice). Right after Cpysplf is executed by QCMDEXC, I received message Id CPF3468. I would love to hear any suggestions. Thank you very much

Answer Question   |  October 26, 2010  12:42 AM
AS/400, AS/400 errors, CPF errors, CPYSPLF

ODBC to AS400 test connection failed
Hi, Im trying to connect to as400 by simply using [B style=”font-style: italic;”>Microsoft OLE DB provider for ODBC drivers. In the specify source data i placed the IP address or my as400 then the user ID and password, but when i tried Test Connection the error is general security error. 

Answer Question   |  October 26, 2010  1:54 PM
AS/400, AS/400 testing, ODBC, OLE DB