• Retrieval of Extended Source Library Information

    Is there a way via FTP to retrieve additional source code line-level details (sequence #, date line of code was changed) from iSeries RPG/CL source libraries? If not via FTP, is there another way to extract and transfer this information?

    Rchapin0 pointsBadges:
  • Help with converting Mainframe file on iSeries

    Hi there, I'm looking for some advice/help on a file that I'm having some trouble with. The file originates from a mainframe, and is sent over to our iSeries (V5R2M0) via Connect:Direct. The file is 3680 Bytes long, comprising of string and compressed numeric data. I have the layout of the file,...

    Nealhudson0 pointsBadges:
  • Job Schedule Entries Migration

    Hi All, We are migrating from an 820 to a new 550 i5 this weekend. Does anyone know how we can migrate the current Job Schedule Entries on the 820 to the 550? Is there an API to the database that holds the Job Schedule Entry details that we can use to extract the info and then push it into the...

    RaydenR0 pointsBadges:
  • Edit .accdb from multiple workstations

    How can I input data in to a database file using microsoft access 2007 from multiple computers at the same time. From my understanding I need to have SQL Server running in order for me to do this, correct ? Also if I do need Sql server can it be installed on a Windows Xp Sp2 machine ?

    Tdizzle34230 pointsBadges:
  • The IT Blog Top 10: Dec. 10, 2009

    10. No Exchange 2007 on Windows 2008 R2 – but why? Brendan Cournoyer delves into why the latest Windows 2008 R2 takes a surprising turn in not support Exchange 2007. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8....

    ITKE332,110 pointsBadges:
  • The most-watched IT questions this week: Dec. 1, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. CompEng asked about open-ended SQL statements, and Mrdenny and Meandyou delivered the goods. 2. Kalpana queried Networking certifications, and where the best place is to get...

    Michael Morisy8,293 pointsBadges:
  • SQLCOD = -7008 when doing an insert into file using SQLRPGLE-2

    Hi, I'm trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am...

    SasiKumar0 pointsBadges:
  • Hiding the system views table from Microsoft Access

    How can you hide the system views table from applications like Microsoft Access? For example, whenever I link to tables in our SQL Server database, INFORMATION_SCHEMA and sys system views are included in the list of tables. This prevents us from finding our tables immediately. How can this be done?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Triggers to Populate Geometry of a Feature

    Hi, Has anyone created a trigger that populates a field with the geometry of that table, where the table contains spatial geometry?  For example, I would like to create a trigger to automatically populate an area (AREA_SQM) or perimiter (PERIM_M) field of a building area feature (AREA_BUILDING)...

    SamAvella30 pointsBadges:
  • 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...

    ITKE332,110 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?

    ITKE332,110 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:

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