Search:

Hello! There is a command in TAATOOLs called CVTJOBQ. If you have TAATOOLS, you should have that command. I've attached a screen image from an SQL session, showing some of the data that is...

Hello! I think Jørn is right, in that the carriage return is causing you a problem. What you could try, is to create a logical file over the physical that does not include the field with the...

You are very welcome.

I didn't realize it at the time, but SYSTABLES is a view/logical. It's built over QADBXREF in QSYS. Try QSYS/QADBXREF, and see if that works.

Also, when I use Squirrel, I can't use a slash for...

Howdy EB! Try this, and see if this is what you're looking for:

SELECT * FROM qsys2/systables

Hello Stuckinparis! The DSPPFM does NOT share an existing open data path, so what you see via DSPPFM is not altered by the OPNQRYF. The CPYF command too does not share an open data path. I would...

Hi! I think the error you are most likely getting is 'Receiver value too small to hold result'. You have SPLNE described as binary, but when I look in the RPG reference manual's INFDS examples, it...

When you add a trigger to a file with *LIBL for the trigger program library, the *LIBL is only used at the time of the ADDPFTRG to find the trigger program. For example, I executed this command:
...

Hello! Here's what I just tried, and it worked fine:

On the iSeries, I created the physical file, and did the CPYSPLF.

CRTPF FILE(BRUCELIB/PRINTER) RCDLEN(132)

CPYSPLF FILE(QPQUPRFIL) ...

Update: I figured it out. I asked the mainframe shop what they added into the internal scripts to FTP between ASCII/EBCDIC machines. It turned out to be 'site xl=us'. We added that to our Windows...

Hello! I have a file that has just one field described, 106 bytes of character data. The file is FTP’d from the iSeries to a Windows box. On the Windows machine, the file looks fine. Next, the...