• Prompting for and passing partial search criteria to queries

    I?ve built a query, based on table containing public school student demographic data, using query utilities (i5/os, V5R3) which prompts for a value when run. The criteria in the ?select records? panel is FIELDLASTNAME EQ :FIELDLASTNAME. When I run STRQMQRY QMQRY(LIBRARY/QUERYNAME) ALWQRYDFN(*YES)...

    Jimmer0 pointsBadges:
  • Reconnecting to databases in SharePoint after server wipe

    My Windows Server 2003 box died which had WSS 3.0 on it. The server has been wiped and I still have the SQL Server intact. Everything is reinstalling now; can I just reinstall SharePoint and "reconnect" to the databases that already are there or do I need to start all over?

    ITKE350,300 pointsBadges:
  • Physical / Logical file definitions

    Can a logical file have fields that differ in definition of type than the physical? I've got a physical file with fields defined as: FLD1 A 20 1 20 FLD2 S 8 0 21 28 FLD3 S 11 2 29 39 and the logical defined as: FLD1 A 20 1 20 FLD2 P 8 0 21 25 FLD3 P 11 2 26 31 Will the data process between the two...

    Houstonpgmr0 pointsBadges:
  • Need to know the journals within a library or a list of libraries and write it to an outfile

    Hi.  Is there an easy way to get a list that will provide information on which physical files are being journaled within a library?  For some reason, I can not find it, but thought it would be available through one of the DSPFD outfiles, but I haven't found it, nor have I been able to find it...

    jamesm33330 pointsBadges:
  • using QDBRTVFD to find SQL view create statement

    Hello all. Just wanted to know if anyone out there knows how to use QDBRTVFD to retrieve the SQL view create statement. For our update process, I am scanning the customer's libraries to find buisiness views. When I find them, I want to extract the SQL view create statement (like in DSPFD) and place...

    Jley6180 pointsBadges:
  • NAC recommendation

    I am doing NAC research for my company to see what would be the best solution to implement it. We having serious problems with managed and unmanaged users coming onto the network which spread alot of viruses, thats why we need control who is coming onto the network.To give you some background info...

    Rishard5 pointsBadges:
  • Retrieving Job Info

    I have a CL submitted from the Job Scheduler. In this job I need to kill an active job before processing, then strat it up again when processing is complete. For the active job I know the User ID and the Job Name and this is it, in addition there will always be more than one job out there (1 active...

    RaydenR0 pointsBadges:
  • embedded sql performance over large files

    We have many applications using embedded sql statements. We are discovering that as the files grow larger the performance diminshes significantly. We have tried using dbmon to ensure indices are not being built on the fly. There are either indices or logicals for all keyed access sequences. Any...

    Bbilgen0 pointsBadges:
  • Best way to create a large access databases.

    I am new to access databases, as I am sure everyone says there first time. One thing I do know is that the database I will create will be very large and I Would like to know is it better to break up the database in to several linked databases together or just have one and live with it.

    Opus35 pointsBadges:
  • Microsoft Access Report

    I am able to alter one of my access reports, but everytime i try to exit and save it the report will not close untill i say no to save changes has anyone got any ideas as it is driving me insane

    Mcrisok5 pointsBadges:
  • User Auditing/Journaling

    I'm new to security on the AS/400 (730). We need to have a record of what program a user calls through our ERP system or what objects are changed and who changed them. I've read some on journaling but not sure if that will work for what we need. Suggestions? Thanks Mark

    Hllwyrs0 pointsBadges:
  • Reading a File of unknown name, format, etc.

    I need advice on reading a data file in RPG where I will only know the file name, the file format, etc. at run time. I would like to use an API or something to read the file into a buffer; I could then use the QUSLFLD API to get field definitions and parse the fields as required. I am not...

    DaddyCOZ0 pointsBadges:
  • How can I split job by determine no. of records ?

    I have a problem. My transaction file is about 20,000 records. This file is used as input/update file. It uses a long time when we run job in day end. I want to use less time. How can I split job to 4 job and each job run only 5000 records? How can I determine as follows ? job 1 process data only...

    Cookiekitty110 pointsBadges:
  • The IT Blog Top 10: Oct. 29, 2009

    10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view...

    ITKE350,300 pointsBadges:
  • RPGLE Flat File

    how can i keyed a flat file in RPGLE

    Hemavijay85 pointsBadges:
  • deal with microsoft access data base file from RPG program or clp

    hello, I need to made clp or RPG program to open microsoft access data base file from my PC then read and update special table from this file thanks best regards laila elsharkawy

    Lsharq0 pointsBadges:
  • Moving spool files from one AS400 to another

    I'm having a problem retaining the spool file attributes when I tranfer spool files from one ISeries to another. I can use the SNDTCPSPLF and it retains most of the attributes but does not retain the user and date/time attributes of the original spool file. Any suggestions??

    Pperry0 pointsBadges:
  • OVRDBF in JAVA

    I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?

    Cganeshh0 pointsBadges:
  • OVRDBF in Java

    I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?

    Cganeshh0 pointsBadges:
  • Data Dynamic Activ Report Version 2.0

    I Have Data Dynamic Active Report Activex, When I load designed Report from vb6 I can show a evaluation message in yellow backgroun How to remove it and also when I give print 1 page printer will print 2 page (With blank page) How to solve this problem or how to hack this proble

    Jadejaashok60 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following