• Using Dropbox and Radio button with DB2400

    IS THAT POSSIBLE OF USING DROPBOX AND RADIO BUTTON IN DB2400?

    Rajasekhar151,395 pointsBadges:
  • override database and logical file

    what the main difference between OVRDBF override database in CL and logical file... which one have most advantage...

    pdsathishkumar3,790 pointsBadges:
  • Problem converting numeric to date data type

    I have a zoned decimal field as s 6 and i am trying to convert it to date format as mmddyy in sql...It giving error ..please help me out ..I tried using date and cast function but its not working !!

    munduuu435 pointsBadges:
  • DB2/400 count physical file record

    how to count the physical file records using RPGLE program....

    pdsathishkumar3,790 pointsBadges:
  • DB2/400 delete record

    how to delete record using UPDDTA command...

    pdsathishkumar3,790 pointsBadges:
  • DYNSLT (Dynamic Select Concept)

    Hello All, This question is regarding the dynamic selection concept in DB2/400. As we know we can create a LF with our without the DYNSLT keyword. The question is what is the difference in using LF with and without DYNSLT? What should I prefer if my PF handles millions of records? Thanks in advance

    BibinG20 pointsBadges:
  • String Aggregate Function

    I need a report that provides an aggregate of a string column - in this case a concatenation of the values in a comma separated string. There is no such DB2 aggregate function that does this. A stored procedure (or possibly a customer aggregate function?) seems the only likely way to accomplish...

    Mgemmill5 pointsBadges:
  • COBOL/400, DB2/400

    Hi Group, I have a Physical file. It has 3 members, memb1, memb2 and memb3. In my cobol/400 program i need to access all the 3 members and put data into them. What is the select statement for the multimember PF? How to declare the file section for multi member PF? The  COBOL/40o pgm should be...

    mvrkrishna555 pointsBadges:
  • Question on Physical Files & Logical Files

    Hi Group, I have a Physical file. I created a Logical file on it with a key field as Primary key. Later as per the new requirements i created a LF with composite key as primary key. Should i make any changes to the LF that was created earlier??

    mvrkrishna555 pointsBadges:
  • How to use “Program-Described-File” for converting an AS/400 numeric field into Char-field

    My situation is..... I have a file which is old & got 18,000 records in it. It has a numeric-field(Amount, Len 9,2). Now the 'Amount'Field in the file is changed to 12-char, in the new library. only this field's name is changed in order to avoid ambiguity. Otherwise the file-name & other fields...

    svankipu620 pointsBadges:
  • How to move an AS/400 numeric field to an alphanumeric field without disturbing the value in it?

    How to move a numeric field to an alphanumeric field without disturbing the value in it. I have a numeric field(9,2) with value MyVar = 9876543.21 I need to move this (as it is)into an alphanumeric field(12 A), without distorting the value in it. But if I use %CHAR, it gets moved along with...

    svankipu620 pointsBadges:
  • How to find number of bytes read/written in RPGLE?

    Dear AS/400 Lovers! In a program, I need to find the number of bytes read from a file(FILE1) & written to another file(FILE2) in RPGLE. I need to maintain this in an Audit-file for Audit purposes. Has anybody done this earlier? any help would be of great value. Thanks in Advance, Svanky

    svankipu620 pointsBadges:
  • AS400 RUNSQLSTM – Problem with CAST

    I am using a RUNSQLSTM to insert records from file A into file B. One of the fiels in defined as 4S 0 in file A and as 4A in file B. If the value in file A is zero, not matter what I have tried file B gets populated with a 0 followed by 3 blanks. I need to be '0000'

    CharlieBrowne41,430 pointsBadges:
  • Transform DB2 to XML from AS/400

    I have been requested to create XML files from AS/400 DB2 files to be used to update data on a client's web server. I have looked at IBM's XML Toolkit for iSeries, but the examples are all about parsing XML input and nothing about creating XML from native AS/400 database files. Is there something...

    LBurkett99830 pointsBadges:
  • How do I INSERT records into AS400 DB2 file from SQL server?

    I can pull data from AS400 to SQL but cannot get my command on the SQL server to push the data back.  This is a very small process, I only need an item number and date. Also, the date on the SQL db is "datetime".  I'll need to convert that to a more recognizable date field to put in the AS400...

    Normap2275 pointsBadges:
  • Improve performance on Insert rows into DB2 400 table from SQL server

    Using INSERT OPENQUERY and a linked server on SQL Svr 2005, to insert rows to DB2 table on AS400. To a local AS400 runs very quickly. Performance on a remote 400 is very slow, and seems to be out of proportion to the change in line speed. Is there anyway to improve the performance for Inserts to...

    Code2live55 pointsBadges:
  • Reading all AS/400 records

    i want to read all the records in a file.. and there are no locks on the file during this process.. how will i read the records in fastest possible manner in AS400

    Nutangujar895 pointsBadges:
  • Responsibilities of DB2/400

    Hi, Being an AS/400 development/admin guy what are the roles and responsibilites of DB2/400(DB/400 ?) on daily basis.  What could be the  maintenance activities. I'm just curious about to know...waiting for your valuable comments..    

    qmaster1,675 pointsBadges:
  • DB2 physical file

    how we can create View with Key to more than one PF in Diffrance Lib exsample LIB                         PF File Name ============================= Lib1                         Custom             (( for HeadOffice ))...

    Hodish40635 pointsBadges:
  • job QZDASOINIT

    My web application is using ODBC connection to access DB2.Connections are closed properly on each page.But job QZDASOINIT is not ending and remain in TIMW status.This is creating large number of jobs on server.How can i close this job when connection is closed?

    Wasifzaheer35 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