• 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:
  • SYNON vs COBOL

    Hi All, This query is related to performance. I am currently in the process of changing an application from COBOL to Synon. The application uses a lot of I/O involving files. Upon converting the application to Synon, I find that the performance has declined - COBOL takes 8 minutes whereas Synon is...

    Rituraj0 pointsBadges:
  • Access list

    I want to config a router to deny any use for TCP port 80. How can I do that?

    Asal15 pointsBadges:
  • Optical storage

    I am trying to copy database files from the iSeries to a DVD (optical storage) and would like the files on the DVD created in ASCII text format. Similar to a data transfer from the iSeries, you can specify the file type ASCII text. The database files are actually spooled files that were copied to...

    Rick1020060 pointsBadges:
  • Logical file to include only one of many matching records in secondaryu file

    I have a one to many relationship between 2 files. Although there are multiple matching records in the secondary file, the fields I am interested in are common. THerefore i only want one of the secondary records to join to the primary record - avaioding duplicate logical records. I know this could...

    JustinDouglas0 pointsBadges:
  • Alternate Collating Sequence

    I have a logical file keyed by email address and defined with ALTSEQ and dynamic select/omit. My problem is if I perform a READEQ for a specific key value, only records with lower-case keys are returned. I expected the upper-case entries to also be returned. Can anyone shed any light on why this...

    Intravler0 pointsBadges:
  • Pipe Delimited CSV File

    I have the following Pipe Delimited data in a physical file: Dealer Name¦Deal Number¦Buy/Sell¦ Joseph Camm¦80740¦S¦IG¦5000000.00¦ After issueing a CPYTOPCD command, I end up with: Dealer NameÝDeal NumberÝBuy/SellÝIG1ÝAMOUNT_amountÝ David CammÝ80740ÝSÝIGÝ5000000.00Ý How do I get...

    Ricca100 pointsBadges:
  • convert from msaccess to sql2005

    SELECT Format(DTrans.DATE,'dd/mmm/yyyy') AS dated, DTrans.trntype as Expr1 , DTrans.JVNO, 'By ' & FINNACCO.ACCNAME , (select analscode from INCEXPAN where analscode=val(DTrans.CRANALSCODE) and accode=craccode) AS CRANALSCODE, '' , DTrans.AMOUNT, dtrans.craCCODE AS accode,...

    Radhikanutalapati5 pointsBadges:
  • odbc data source

    odbc data source not displaying all dbs when pointing to sql2008. Only shows default db. odbc data source that points to sql2000 shows all dbs user has access to.

    Dowens20 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