• Data Access Layer in RPG

    Has anyone implemented a Data Access Layer in RPG-ILE, similar to what is discussed in these articles: http://www.itjungle.com/fhg/fhg072104-story01.html and http://www.itjungle.com/fhg/fhg011205-story01.html If so, can you share some of the positives and negatives of the experience? In hindsight,...

    johnpquinn5 pointsBadges:
  • Help with Database Structure

    I need to create a databse that keep track of a Item # and associated with that Item# is 2 type of people. DonorID and OwnerID. Both these type of people i want listed in the same Table. So far my structure looks like so....

    Tdizzle34230 pointsBadges:
  • Migrate repository from SVN to VSS

    hi experts, I just would like to know how to migrate the repository from svn to vss or svn to starteam As former case many suggests as bad idea in different forums,I am not familiar with those please guide me If any one is possibble,how can that be Migrated using what tools ?

    Inprise610 pointsBadges:
  • updating char

    update operator set ascii(REVOKFLG)='0' where login like 'ospprov' error missing equal sign.

    Gunzforlife40 pointsBadges:
  • updating char in Oracle 10g

    how do you update a char in 10g

    Gunzforlife40 pointsBadges:
  • Problems eliminating HEX 41 character.

    I have a number of files on my DB2/400 database that have spaces with a Hex code of 41 instead of 40. This causes a problem when FTP'ing to a PC for integration with a barcode labeling application. Does anyone know how I can change this character to ANYTHING other than Space HEX 41 !! Potentially...

    Selectsoft65 pointsBadges:
  • Database being auto duplicate when exit.

    hi you, i've created a database for my dept and place it on shared server. The problem is everytime user exit from the database, there will be a duplicate of database at the server. Example: my database file name is correspondence_log.accdb, when user finished used the database, there will be an...

    Nurul29815 pointsBadges:
  • AS400 disk initialize info

    Hi All, I am trying to find printable results or logs for a disk that has been initialized successfully by using SST or DST. The procedure normally completes with a single line of "COMLETED SUCCESSFULLY" I need more infomation like model, serial no, sectors or some proof that this particular disk...

    Jf79210 pointsBadges:
  • Comparing 2 files .CSV and getting the missing data using AS400.

    I have 2 files of .CSV format. I need to compare them and capture the missing data into Excel sheet. How do i do this using AS400???

    0 pointsBadges:
  • FTP from iSeries DB2 to iSeries AIX (Oracle)

    I'm taking a FILE and using CPYTOIMPF to either create the flat file pipe delimited to another DB2 File or directly to the IFS as *PCASCII. Using iSeriesNavigator, I have no problem looking at the IFS. No issue with iSeriesNavigator and looking at FILE either. Using FTP, <namefmt 1>, <mode...

    Dlanor20 pointsBadges:
  • AS400 Query Join

    I need expert help. I need to create a query that will use four tables. Each table has a column of data that I need for the report. The end result should display the following: Name, City, Amount, Reason.  Here is my first query that gives me the name and city: SELECT "T16.GNAM".N_NAME,...

    lorit365 pointsBadges:
  • duplicating records in Microsoft Access 2007

    Why are all of my records duplicating themselves in the format part of my access database? I am not entering them in duplicately, they are duplicating themselves.

    Bkerner5 pointsBadges:
  • AS/400 Query Join

    I am joining four files. Each file has one field I need for my report. How do I determine which file is the primary one? Should the select records criteria all come from the primary file? As long as I test fields First>Second, Second>Third, Third>Fourth, shouldn't it work just fine?

    lorit365 pointsBadges:
  • SQL RRN Processing – by Key?

    I'm putting together a job that needs to process a large masterfile in a very short period of time. To do this, I'm (sorta) cloning an existing SQLRPGLE application that runs multiple concurrent copies of a program...each processing a range of the file by RRN. The number of copies is dynamic, set...

    ChuckM0 pointsBadges:
  • AS400 intreface with other platforms

    Can anybody tell me how to interface As/400 with other platforms say windows or linux for example

    Cute98862892710 pointsBadges:
  • How many rows will a FETCH statement return in an explicit cursor operation?

    HOW many rows will a FETCH statement return in an explicit cursor operation?

    Mbreckenridge8135 pointsBadges:
  • Database concepts

    What is a database? what are the steps to creating a database?

    Richardizuchukwu10 pointsBadges:
  • Using two same files from different libraries in a RPGLE program.

    Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime.So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve...

    navinnegi45 pointsBadges:
  • Is it possible to reorganize a very big transaction in one night?

    I want to reorganize a very big transaction file in day end process and it cannot finish within 1 night. The problem is RGZPFM command lock that file ,so the day after , user cannot use that file because it is locked. Do you have any ideas to help me?

    Cookiekitty110 pointsBadges:
  • Commit utilization in SQL stored procedures

    I need an explample of an SQL stored procedure running in an DB2 environment that uses commitment control. I don't want use RPG. I would like to call it from QSQLSRC via LXISCH (AS400 scheduler) and update over 100,000 records in 20,000 row increments. Any Suggestions? Thanks!

    Whitera0 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