How do I display a clickable link from database in table using PHP?

I have a table and when I pull a clients info up I would like the web address to be able to be clicked to view web site. How would I code this in? Here is some of my code. $num_rows = mysql_num_rows($query); print “<b>Here is my Information on you. <br><br>E-Mail me with any changes.</b><P>”;…



Answer Question   |  June 27, 2012  4:23 AM
Database, Display File, PHP, table
asked by:
5 pts.

Problems with DB2 program

I have a COBOL program that calls a db2 stored proc program. I get corrupted o/p records when reading the input file from CARTRIDGE. The same records, when copied to DASD, come out fine. Same code, JCL, etc. WTH! Is there a parameter that I need to pass to the system with PGM=IKJEFT01 to solve…



Answer Question   |  June 27, 2012  4:21 AM
AS/400 Parameters, COBOL, DB2, DB2 administration
asked by:
5 pts.

LogOnServer Problem in Crystal Report

I am using VB6 with back ground Database DB2 AS400 iSerices and Crystal Report 9.0. When I Show the Report Its prompt me to enter password. I have tried to find the solution and found some thing about LogOnServer but every example is there for Crystal Report 7,8, and 8.5. I have tried to use…



Answer Question   |  June 27, 2012  4:20 AM
AS/400 DB2, Crystal Reports, VB
asked by:
130 pts.

Cobol access to DB2 data over multiple LPARs

I have an iSereis with 2 LPARs – one running V6R1 with a Cobol compiler (not ILE) and the other LPAR is running V5R3 with DB2 files.  What code and/or compiler options do I use to connect the v6r1 Cobol with the v5r3 database and how do I create the Cobol program to run on…



Answer Question   |  June 27, 2012  4:19 AM
AS/400 LPAR, COBOL, DB2, iSeries V6R1, LPAR
asked by:
5 pts.

Printing barcode from Acrobat (pdf) to Zebra printer.

I would like to have a programmed button in Acrobat to “PrintBarcode” to a Zebra printer. The default print buttion prints the pdf form using a java script. How can I send the ZPL code to a printer com port?



Answer Question   |  June 27, 2012  4:18 AM
JavaScript, PDF, PrintBarCode, Printing, Zebra printers, ZPL code
asked by:
Was
5 pts.

AS/400 administration book with screenshots

Can anyone refer me a as400 administration book with screenshots.



Answer Question   |  June 27, 2012  4:15 AM
AS/400 administration, Recommended reading
asked by:
45 pts.

Get AS/400 FTP session to echo back data and time

Frequently our AS/400 sends data to our bank via FTP. The bank returns a 220 welcome message in the FTP log which includes the time. We would like to also see the date from the bank’s UNIX computer recorded in our log. I’ve tried a couple of things in our FTP script but the commands…



Answer Question   |  June 27, 2012  4:13 AM
AS/400, AS/400 FTP, FTP, V5R4
asked by:
5,525 pts.

Performance issues with ESS Salary Statement and default pritners setup

We are having performance issues with the ESS Salary Statement displayed in our portal when there is a default printer assigned other than LOCL in the back-end ERP user master data. When the assigned printer is LOCL or if there is no printer assigned, it takes about three to four seconds, but if another printer…



Answer Question   |  June 27, 2012  4:11 AM
ESS Salary Statement, LOCL, SAP ERP, SAP ESS, SAP HR, SAP printing
45 pts.

SELECT with LIMIT in AS/400

Hi all, On my AS400, I need to select the first 90 records from one file and insert them into another file, but all the time i got all records in my result file. Is there any way to use the parameter LIMIT with my SQL SELECT INSERT INTO LIB1/FILE1 (FILE1) SELECT DISTINCT                  (substring(FILE1, 1,…



Answer Question   |  June 27, 2012  4:11 AM
AS/400 Parameters, AS/400 Records, SQL, SQL Select
asked by:
250 pts.

Domino Server e-Mail Formatting

Using Domino Server Version (8.0.2) I have a script in the IFS that gets copied from STDIN to a temp IFS file. The temp IFS is set in ASCII ccsid=819 The body text is a 142 character, no embedded CR or LF or CRLF I use the IBM API QtmmSendMail to deliver the e-Mail. This…



Answer Question   |  June 27, 2012  4:10 AM
Domino Server, IFS, Lotus Mail
asked by:
20 pts.

The IT Blog Top 10: Oct. 1, 2009

10. Choosing a block size when creating VMFS datastores Eric Siebert provides a guide detailing how to choose a block size for VMFS datastores. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover walks through Sun’s xVM VirtualBox’s ability to tap into VRDP remote viewing. 8. Does Larry care about Oracle customers? When…



Answer Question   |  June 27, 2012  4:08 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, IT Blogs, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
asked by:
6,893 pts.

The IT Blog Top 10: Oct. 1, 2009

10. Choosing a block size when creating VMFS datastores Eric Siebert provides a guide detailing how to choose a block size for VMFS datastores. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover walks through Sun’s xVM VirtualBox’s ability to tap into VRDP remote viewing. 8. Does Larry care about Oracle customers? When…



Answer Question   |  June 27, 2012  4:08 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, IT Blogs, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
asked by:
6,893 pts.

Infinium using FLSA pay rates

How can Infinium be configured to pay overtime based on FLSA regulations.



Answer Question   |  June 27, 2012  4:06 AM
AS/400, Infinium, iSeries, Software 200, System i
asked by:
5 pts.

Remote Location Services – i5/OS

To All, We are located in Concord, NH and are looking for an out of state service that would provide remote redundancy for our Production Servers.  We are primarily interested in a Disaster Recovery Solutiion, not necessarily a High Availability solution. Thank You, Bill



Answer Question   |  June 27, 2012  4:04 AM
i5, i5/OS, Windows Server 2003
asked by:
2,480 pts.

AS400 – BRMS

I was saving all spool files using BRMS control group on a V4R5 system. Had an issue that the folder q1abrm was full. The job/BRMS was retrying to populate that folder for several hours. I exluded DEBUG and QEZJOBLOG outqs.  How can I resolve this?



Answer Question   |  June 27, 2012  4:02 AM
AS/400 BRMS, AS400 backups, BRMS, BRMS Backup
asked by:
40 pts.

infinium file names

i have experience with infinium but it has been a while. can someone send me the file names or structures of infinium software, AR, AP, Fixed assets, payroll? any of them will do thanks



Answer Question   |  June 27, 2012  4:01 AM
Infinium
asked by:
5 pts.

running queries in infinium application manager

Is it possible to have a wrkqry command in an infinium menu to generate reports. Do you have to have access to specific objects?



Answer Question   |  June 27, 2012  4:01 AM
Infinium Application Manager, WRKQRY
asked by:
5 pts.

V4R4 upgrade to V5R4 or V6R1 WDS

I need some more expert input on this issue. I am currently on a S30(V4R4). Yes i know its old, but it has lasted 12 years. I now have the option to go to a preloaded  520(running with V5R4 or V6R1 OS & lic pgms). My V4R4 box has the STRPDM cmd where I can compile…



Answer Question   |  June 27, 2012  4:00 AM
iSeries, iSeries V6R1, V4R4, V5R4
asked by:
120 pts.

V4R4 upgrade to V5R4 or V6R1 WDS

I need some more expert input on this issue. I am currently on a S30(V4R4). Yes i know its old, but it has lasted 12 years. I now have the option to go to a preloaded  520(running with V5R4 or V6R1 OS & lic pgms). My V4R4 box has the STRPDM cmd where I can compile…



Answer Question   |  June 27, 2012  4:00 AM
iSeries, iSeries V6R1, V4R4, V5R4
asked by:
120 pts.

Compare part of string to field

Hi.  Hopefully a simple one but beyond my self-taught abilities in iSeries SQL.  I have a file with one field containing customer order details including their purchase order reference such as ‘A1-123′.  The first part of the PO reference is a branch identifier.  Unfortunately, as it is a free text field, it is sometimes expressed…



Answer Question   |  June 27, 2012  3:55 AM
iSeries SQL, iseries v5r4
asked by:
35 pts.