Description:
IBM AS/400 miscellaneous topics.
|
|
|
SQL Triggers
|
| |
Is it possible to write pure sql triggers for Iseries instead of RPG COBOL etc.?
what licpgms should be needed?
We are on V5R4M0
Thanks in advance.
-- .
|
|
Navigating IBM's websites and figuring out their product offerings... Sheesh
|
| |
So I downloaded a trial version of "IBM Rational Developer for Power
Systems Software", version 8.0.3, and I tried to create a remote C++
project and my only options are AIX or Linux. I care about neither of
those platforms. I want to test creating C++ & RPG projects for a
System i. Am I doing something wrong? I don't use an Eclipse-based... more »
|
|
Finding individual jobs memory usage?
|
| |
I have a long-running program that I want to monitor the memory usage
on. Just want to make sure it isn't running away crazy. So far I'm
coming up with nothing. Systemi Navigator isn't returning any results
to me so something isn't configured right or I'm blatantly doing
something wrong. Seems like pretty basic information everyone would... more »
|
|
MCH1825 - Problems with select/omit in OPNQRYF on an LF (Paging Dr. Pence)
|
| |
We have a batch job that intermittently gets an error MCH1825 followed by CPF5147. The job does an OPNQRYF on a logical file specifying QRYSLT. It then calls an RPGLE program that positions the file using a relative record number in SETLL. It then reads from the open data path and processes records until it reaches the highest RRN it is to process,... more »
|
|
Print server setup
|
| |
Hi all,
On an old 270, I'm trying to print to a Hawkings print server which is attached to a IBM 6400 line printer, parallel port.
I created a printer device using: CRTDEVPRT DEVD(BADDOG) DEVCLS(*LAN) TYPE(3812) MODEL(1) LANATTACH(*IP)
PORT(9100) FONT(11) FORMFEED(*CONT) PARITY(*NONE) TRANSFORM(*YES)... more »
|
|
How to handle 'graphic' fields
|
| |
Hi.
I'm trying to query DB2 table on iSeries,
DSPFFD for most of fields shows values:
---
PSTLZ GRAPHIC 10 20 265 Both PSTLZ
Default value . . . . . . . . . . . . . . :
UX'0020'
Coded Character Set Identifier . . . . . : 13488
UCS2 or Unicode conversion . . . . . . . : *CONVERT... more »
|
|
conversion tables problem
|
| |
Hi,
Table on iSeries has CCSID 13488 (I used DSPFD command to check),
system values on OS are:
QCCSID -
Coded character set
identifier . . . . . : 65535
QCHRID -
Character ID . . . . . : 697
Code page . . . . . . : 37
All I need is to query that table from Linux with iSeries Access... more »
|
|
ODBC double quote problem
|
| |
Hi all,
Got some Excel data trying to upload to the iSeries. I import it
into MS Access and then use ODBC/append query to upload to the
iSeries. 1906 rows are successfully inserted into the iSeries table.
Most of the rows have double quotes (") embedded in a text field
(table contains product that is sized by inch), but 6 rows return... more »
|
|
AFPDS -- Special Symbols
|
| |
I've just gotten started using PRTFs with AFPDS. Having some trouble
creating special symbols -- namely a bullet. I tried to do hex value
x'2022' but that didn't work.
Has anyone ever worked with these?
|
|
Useful info missing from DB2 system catalog
|
| |
SYSCOLUMNS view in QSYS2 can be queried to find columns defined as VARCHAR, but the row does not contain a metadata column to show the allocation size of the VARCHAR column. Is there a way to find the allocation size of a VARCHAR column without doing a DSPFFD on the table or file?
|
|
|