• Mainframe Career – is it possible for me?

    Hello, I have been working for a MNC in India for the past 2 years. My nature of Job includes creating SAS programs and using JCL to run this SAS and get reports or other stuff from the DB2 databases or files. I also write simple SQL queries for DB2. I am right now in a stage where I need to decide...

    Richard19835 pointsBadges:
  • SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.

    Please I need an SQL command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype. My Oracle database is on Windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...

    IdongesitDaniel5 pointsBadges:
  • Print Image File in iSeries

    Hi, I would like to ask for help to use the data type field GRAPHIC in iSeries. Can I save an image file into this field type? If so, how do I do this? I have tried but it always shows an error of character conversion not valid. Please help. Regards, Tony Tam

    Tonytam0 pointsBadges:
  • Oracle Import to Linux

    I have full export dump from Oracle database version 8i from Vax/alpha machine. I want to impoet to Linux system which has Oracle 9i installed What steps should I do?

    Singhbb0 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:
  • Db2/AS400 library connecting via oledb in vb.net

    I have been trying to connect a vb.net datalink property to a specific library on a 400. When I fill in the field "Enter the initial catalog to use" I get the message that the catalog is invalid. I have thought it might be a path on the 400, such as QSYS/MyLib, but that errors as well. What am I...

    Vatrix0 pointsBadges:
  • How to select 1 record in DB2

    As usual, I often use: select top 1 * from table but in DB2, I can't. I use the Toad tool to input SQL statement. Does anyone have a solution? Please share it with me. Tkanks a lot!

    Linhntk5 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:
  • How to find indicator and relative record number fields in DB2/400

    In DB2/400, even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value "Y" or "N". How to see this indicator field? How to see the DB2/400 RRN (Relative record number) field? I tried with RUNQRY...

    BibinGeorge130 pointsBadges:
  • How can I connect DB and input values in stored procedures using VBA

    Hi all, I'm using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me.

    Jprpvk5 pointsBadges:
  • Conversion of SQL Server 2000 to iSeries DB2 V6R1

    Hi there. We are converting SQL Server 2000 to DB2 on iSeries V6R1. We’re ok with the JDE tables and views, but are having difficulty with the non-JDE tables, views, and stored procedures. Is there a tool or something that could help us? Thank you.

    Tprusko5 pointsBadges:
  • How do I retrieve the JOB/USER/NBR for a spool file generated by a GUI program?

    I have a GUI program which HAS to run interactively that generates a spool file. The HTTP job (Which is what I correctly retrieved using RTVJOBA & QUSRJOBI) is: Job: VOI User: QTMHHTTP Number: 303484 But the job that my spool file has is: Job: QPRTJOB User: <My user ID> Number: 303384...

    Orelalaith0 pointsBadges:
  • External DB2 Database link/trigger

    In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables.

    r.otto810 pointsBadges:
  • bi-directional data synchronization on System i for db2 databases

    I would like to know what would be the best ways to have bi-directional data synchronization on System i between db2 databases. What are the best ways to synchronize data between DDS and SQL-defined files that belong to different applications?

    Aroyzen15 pointsBadges:
  • How to use API to access DB2 file on iSeries

    Gredon would like to access (search, read, insert, update and delete) a DB2 file on the iSeries with an API. He said he's searched the IBM manual, but he couldn't find the APIs that he can use. Can you help him? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson435 pointsBadges:
  • Good PL/SQL user guide

    I am interested in a good reference guild for PL/SQL which explain all utility commands and configuration patterns and files. Your help is much appreciated.

    Hfeshari0 pointsBadges:
  • Calling a URL length more than 200 from CLP

    Hi Techies, I would like to call a URL by passing some input values and retrieve some values from the results. The URL lenght is more than 200, with special characters like % " < / > I need to retrieve values from the particular website. Can you please help me out soon, its been getting...

    as400dev505 pointsBadges:
  • DB2 to Text File Conversion and Transfer

    I have created a Text File from my AS/400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this?

    gvdsswami20 pointsBadges:
  • Convert XML to DB2 file

    We still use the command to convert DB2 file to XML (RUNXML) and need a verse option to convert an XML document to a database file.

    UWeber5 pointsBadges:
  • Create DB2 table relations

    There is a requirement to have a subset of data available in DB2 tables in production to a test environment. There is no relationship defined in DB2 (so info available in catalog relationship tables). Now we need to find the relationship between the tables using some automation process. So we might...

    Toramky5 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