• The most-watched IT questions this week: Dec. 8, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Pushan1234 asks about Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime. CarlosDL and MrDenny provide some pointers. 2. Bonbon78 runs...

    ITKE345,300 pointsBadges:
  • compile commands in RPG

    hey all! i am working on a project where i have to use compile commands for various member types, such as CRTRPGPGM for RPG, CRTPF for PF and so on.. but these commands have to run in the background, and the user should know nothing of it, i.e. it should be program oriented. how can i achieve this?...

    Sairolla0 pointsBadges:
  • DB2 Load Utility

    If I run the DB2 LOAD utility LOG NO REPLACE is all the data externalised to DASD immediatley ? I.e. if I ran DSN1COPY against the underlying VSAM dataset immediately (without stopping pageset) would all rows be copied ?

    Ian in Uk5 pointsBadges:
  • Performance issue

    Hi I am using an OPNQRYF in a program which is used quite frequently. Now, the program takes about 20 secs when called once. I tried to create some logicals which can expedite the access to files but there has not been any appreciable change in the performance. Can anyone suggest any other method...

    Pgsdeb20 pointsBadges:
  • souce file listing

    hi all! i wanna know how can i retrieve the names of the components of a Source Physical File i.e. the names of the souce code (members) within a particular Source Physical File...i want ot retrieve the names and store in a database file and later use them for subfile operations. kindly help me...

    Sairolla0 pointsBadges:
  • Performance Problem

    We are experiencing intermittant performance problems most likely related to the update of a file that saves emails sent to customers. The problem may be related to a 10,000 byte text field for the body of the email message and/or the size of this file (2 million records). The file has one index...

    Ashnirody100 pointsBadges:
  • 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?

    ITKE345,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:
  • Building an xml in java

    Please give me an example of building an xml with multiple child nodes, in java. I want something like : <Parent> <Child1>something</Child1> <Child2>something else</Child2> </Parent> Now, the values for Child1 and Child2 must be picked using SQL from AS400....

    Siri55 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:

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