• Data migration strategies-2

    Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel...

    Hazermark0 pointsBadges:
  • DB2 ?

    This may sound stupid, But are files created with DDS on the AS/400 DB2? or some other database type? This would include indexed, non-index and logicals. Thanks

    RPGCRAZY30 pointsBadges:
  • CPF5152

    Hello, I am experiencing a strange problem that is driving me crazy. First what I am attempting to accomplish is to read a DSPF file looking for specific output records and then write to a source file lines of RPG III code to output to those fields. What is happening is that after the 44th line of...

    Joven10 pointsBadges:
  • pl/sql ref cursor question

    Hi, I'm trying to figure out if this is possible in Java OPTION 1 ================== 1. Obtain a ResultSet by querying a non-oracle database 2. Cast the resultSet into an OracleResultSet 3. Pass the OracleResultSet into a pl/sql stored procedure for processing OPTION 2 ================= 1. Obtain a...

    Ajhaveri0 pointsBadges:
  • DB2 not making the FINAL CALL to my user-defined function

    UDF is written in RPGLE, and the CREATE FUNCTION specifies SCRATCHPAD and FINAL CALL. When I do an INSERT statement with the UDF specified for one of the columns, I get called twice. The first has a CALLTYPE of -1, and the second CALLTYPE is 0. I'm expecting a third invocation with a CALLTYPE of 1,...

    JBTaylor0 pointsBadges:
  • SQL Alias visibility

    We have found that creating an SQL alias works for accessing file members in embedded and interactive SQL. But if we create an ALIAS in our live libraries with the intention of keeping it for frequent use, how do we know it exists other than WRKOBJ? It doesn't show up in DSPDBR. And is there really...

    LeslieL40 pointsBadges:
  • Year in Date or Timestamp value is not in the correct range (C G D F).

    Hi All, I am getting the above error when trying to write the control format of a subfile. The DDS is coded as follows: A O_ESD L O 9 70DATFMT(*MDY) A MAPVAL(('01/01/40' *BLANK)) Not too sure what the MAPVAL will do as I dont think it can ever be blank. Basically in the compile listing of the RPGLE...

    RaydenR0 pointsBadges:
  • SQL Function to return triggered update columns?

    We need to retrieve the code that defines a trigger. Not just the code of the trigger(systriggers.action_statement) but the full create statement. I think we have all the elements except for the list of columns in the UPDATE OF clause. This information can be retrieved as follows: SELECT...

    Faddydaddy19510 pointsBadges:
  • function not found – 2 questions

    I wrote a function to change a date in character *USA format to *ISO character format. There is a lot of data to insert and all the dates are in *USA format rather than ISO format. The function is created but running the statement, I am told the function does not exist. Why isn't the function...

    TimRaz0 pointsBadges:
  • AS400 Console

    What effects are caused if you vary off your console session on the AS400 and you do not have any other consoles to take over? I want to move my console to another location in my DataCenter, but I have to disconnect it from the AS400 and reconnect it. Will varying the device off to disconnect it...

    Bkr0963c0 pointsBadges:
  • Number of records in the Flat file

    I have a huge Flat file in the Mainframe. What is the quickest way (utility, TSO command or TSO function) to find the exact number of records in the file? Thank you for your help!

    Yuriymusheyev0 pointsBadges:
  • Passing variables in SQL

    I am writting a CL program that will create and update a table. I am using the command 'runsqlstm'. I am able to build the table but when I try to populate it I am having a problem. I am using the following statement 'insert into qtemp/rrtemp values (&rec). SQL will not process a CL variable. It...

    RREXPST0 pointsBadges:
  • Can not figure out this error message

    I am creating a table and tring to insert headings into it but I keep getting this one error and I just can not figure it out. Please help if you can. The first statement is: "create table qtemp/rrlib (hdgs char (3000 ) not null with default" Then my insert statement: "insert into qtemp/rrlib...

    RREXPST0 pointsBadges:
  • Sql

    When I execute this Sql command. I get an error "Column BASEDATA1 not in specified tables." I have a field in IN$FPS00 that I want to include in 'where' condition and update the rest of the fields in this file. Field Basedata1 is in the table. UPDATE IN$FPS00 SET I@R01 = Sum(BaseData1) WHERE...

    Msabsh0 pointsBadges:
  • Locate DB2 files on the iSeries

    Henry wrote in with this question recently: "I work with Window-based platforms and know nothing about the iSeries. I need to locate DB2 files on the iSeries and copy or export them to a Windows XP machine where the data will be used with another application. Also, somewhere in the process, I need...

    DebraTart0 pointsBadges:
  • Issuance of CREATE ALIAS

    Inna wrote in with this question recently: "Will the issuance of CREATE ALIAS statement lock the actual file member?" Do you know? -- Deb Tart, associate editor

    DebraTart0 pointsBadges:
  • FTP

    When I transfer a file (FTP) from one system to another using Get command numeric data comes as junk. Does anyone know how I can retrieve numeric data ? Thanks

    Msabsh0 pointsBadges:
  • Replicating data between I-series and Ms-CRM using Scribe?

    We are implementing MS-CRM on an Ms-SQL server. We need to replicate data from our business system (I-Series) to CRM, and similarly from MS-CRM to I-Series. Our Ms-CRM provider proposes using a product called Scribe to do this but has no experience of using this with I-series. Has anyone used...

    Peterax0 pointsBadges:
  • A copy tool??

    Hello to all, I am a COBOL programmer working for a life assurance company which uses a life assurance package developed on the iSeries. I have been tasked with looking into whether it is possible for us to copy a 'contract/policy' from our live environment to a development/test environment. This...

    ITnavan0 pointsBadges:
  • File size for DB2/iSeries

    When CREATE TABLE (PRIMARY KEY) is executed and before loading rows, the sizes related to the files are: DSPFD Data space size in bytes . . . . : 24576 Access path size . . . . . . . . : 139264 Total of member sizes . . . . . . : 163840 DSPOBJD Size . . . . . . . . . . . . . . . : 188416 Why are...

    Jobregonr0 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.