Search results for query: *

I have two PCs on my desk. Both run the same version of client access. When I do a print screen from one PC, it prints fine. When I do a print screen from the other, the font is larger and the CPI is smaller causing the print screen to be very hard to read. I've compared both PCs side by...

I have a flat file i want to update via SQL. I am not very proficient in SQL so I'm not sure how to do this. I have three files I need to access in this statement: EPLP14 - Flat File CSB6REP - Landlord File CSIOREP - Phone Number File If the landlord (B6KINB) NE *Zeros (CSB6REP file) link...

First of all, we have NO embedded sql on any of our systems for me to refer to. I am experimenting and my program is probably full of don'ts. I'd appreciate anyone's suggestion/explaination as to why this is taking as long as 5-8 minutes to process 31 files. (Maybe that is normal? I don't...

Could anyone tell me how to change the SQL below to populate by relative record number or the arrival sequence in ASCOMM? The file does not have a sequence number in which to sort the order the comments were added, so arrival sequence would work for what I need. Thanks...

Is it possible to use a variable when using CALLB? Depending on the selection, i want to CALLB different programs. Not sure if this is a subprocedure thing, not realy familiar with those yet. Any suggestions would be greatly appreciated!!

In a query I can display five records equal to the key I am using within my program, but when I reade within my program, I am only accessing three records. It's like it's reading every other record. Any ideas??

I am trying to display messages from a message file to a message subfile in a program. The messages are never displayed in the subfile. When you view the job log you can see the correct messages, but they are never moved to the message subfile. I Any suggestions would be greatly...

I'm trying to display a minus sign when a user enters a monetary value on the screen and uses the field minus key. Instead of displaying a minus (-) sign a bracket (}) is displayed at the time of input. If the field is output only, edit is displayed correctly. It's only when the user is...

Ok, this is probably a really dumb question, but I cannot find any examples of reading one file via SQL and adding those records to a physical file in QTEMP. I am using these statements within an RPGIV program. The SQL statement I am using to read the file is: SELECT nnam, nadd1, nadd2...

I came across an op code i've never seen before in an RPG program. The op code is 'DUMP'. Anyone know anything about this or why you would want to use it?

I want to override a database file to a user supplied member name within my RPG program using QCMDEXC. I created the command in a table and use that to populate the parm to QCMDEXC. How do i pass the user supplied data to the command? The command expects a '&' but i cannot create that type of...

I have a subfile program that is loaded via SQL. I want to add a "position to" field to allow the user to reposition the subfile. How do I code the SQL to perform this function?

I am trying to create an SQL statement that will be populated by the user. The problem I am experiencing has to do with the quotes needed around the selection. When I define a constant field in the D specs i have to define it as '"', but what i really want is '''. How do I get around...