Search results for query: *

If you create the file with sql you can use the for column feature. In the example below when the file is brought into excel the column heading is Finish_Wgt but in rpg programs I use the field zfwgt. create table mylib/myfile Finish_Wgt for column zfwgt dec (5,0) not null with default

Sometime between yesterday & today our startup options were changed so that there is no application title displayed, no display form & the display database window box has been checked. If I change these settings to what they should be they just go back to what they were. As far as I know no one...

We use a switch on the display file. grace

I belong to the rpg mailing list at midrange.com, I used to belong to the midrange list, but there was too much activity for me to have to sort through all of those emails. I do go to the archives for midrange when looking for answers there are very knowledgeable people there. grace

You could do a save(*yes).

The command on the 400 is crtusrprf, F4 to prompt. grace

Yes, use a klist with the 2 variables as your kflds.

Packed fields are not even an option for screen fields are they? If you prompt on an 'a' spec & then hit f1 on data type P is not a valid type.

RTVMBRD FILE(Library/File) NBRCURRCD(&RECS) grace

There is a drawer keyword in the ovrprtf command OVRPRTF FILE(REPORT) TOFILE(P9) DEV(P9) PAGESIZE(66 + 132) LPI(6) CPI(10) OVRFLW(60) DRAWER(1) + OUTQ(P9) FORMTYPE(P9) COPIES(1) HOLD(*YES) grace

1st If you have the authority you should be able to map a network drive in explorer. \\servername\foldername 2nd When you go into operations navigator to open file systems are you going in as qsecofr? grace

You can capture if the enter key was pressed in the information data structure. FSCREENFM CF E WORKSTN F INFDS(INFDS) D INFDS DS D KEYUSE 369 369 C KEYUSE IFEQ...

Sorry I posted the rpgiv example. This can also be done in rpg/400 using the ispecs. FCAR612FMCF E WORKSTN F KINFDS INFO IINFO DS I...

D INFDS DS D KEYUSE 369 369 C KEYUSE IFEQ '1'

CALL PGM(LABDATE) PARM(&RFDAT &TFDAT) Is this program actually filling these dates? Was that a picture of your lda? Is that data in the lda correct? Your cl program says to pick up the dates in 1-6 & 7-12. Also what about the date that says 096001? I know there are a lot of questions...

opnqryf is notorious for its adding of extra ticks '''' Lets try this again, your qryslt statement should be ('GLOBJ *EQ "6323 " *AND GLDGJ *EQ %RANGE(' *cat &RFDAT + *cat ' ' *cat &TFDAT *cat ')') note: there needs to be a space before and after each cat & also a space between...

Try this %range(' *cat &rfdat *cat ' ' *cat &tfdat *cat ') grace

What is your opnqryf question?

try - DSPFD FILE(MYLIB/MYLGCL) TYPE(*MBR) OUTPUT(*OUTFILE)+ FILEATR(*LF) OUTFILE(QTEMP/FDTEMP) the field name in outfile that has the based on physical file name is MBBOF grace

If you are using CODE/400 this is an option. Actions/Convert selection to C Free-Form Actions/Convert all to C Free-Form Grace