• embedding sql to rpgle

    couldd someone pls help me wid generating week number of a year in rpgle. i guess its done thru embedding sql into rpgle pls help

    Atti123135 pointsBadges:
  • Create a querry to select certain records from a Acess Table

    I am creating an Access database that contains a lists of tasks. MY QUESTION IS is there a way to create a query to pull a subset of those tasks to be included in a job? As new jobs are created, I need a way to include a new subset of tasks in a report without have to input all of the tasks...

    Stevek4910 pointsBadges:
  • find min/max date in access which also return their value for each record

    I have a table with more date per record (ID1 thru ID10) and the each date have a score, I want to select from each record of their min date and max date with their score (the score is not the min/max score), the data set is: ID    Date              Score 1     12/03/2003    ...

    Find5 pointsBadges:
  • Simple question about AS/400 query

    Maybe for you that will be a stupid question, but I'm taking the first steps and I don't know what exactly I have to do in the "Specify how to join files" screen. If I put more joints in more rows it is how there was an "and" before every new row? I mean, all the rows are conditions that have to be...

    Fabio5 pointsBadges:
  • AS/400,db2/400,rpg/400

    is there any perfect method to make externally described file fields available to a program

    0 pointsBadges:
  • delete records from a directory with IFS root using CL

    How to delete records from a directory with IFS root using CL based on the timestamp of the records.

    Manish8465 pointsBadges:
  • Diplaying Records From Table In A Form Without Having To Use A Query

    I have a program on the shared drive. I have a user ID & Password Form and table, Production Form and table. I would like to know how to write a macro or program a command button when selected would allow the indivdual based upon their user ID/Password to go to the production table and display all...

    Mecervenka5 pointsBadges:
  • DB2 Table Size in V6R1

    Upper limitation of Table is 1.7TB in the V5R4 version. How about the limitation in V6R1?

    David Chen20 pointsBadges:
  • database management system

    what are the advantages and disavantages of database management system

    Babafemi5 pointsBadges:
  • COBOL date reformatting

    I am getting a date from DB2 and I need to reformat it in COBOL. It will eventually be used in DOC1 so I need it to look like a date (i.e. with slashes or dashes). DOC1 was not recognizing the date I am passing in because right now it is just a numerical string, so I could not cast it as a date in...

    Skmcm40 pointsBadges:
  • How to learn DB2?

    How to learn DB2? Is there any possible way to install in a PC and practice? if then guide me please...............

    Sriramsankarc10 pointsBadges:
  • AUTO INCREMENT

    We created a File with an Auto Increment Field using MYSQL statements through PHP. I have no Idea how to do this using DDS statements or settings.

    Steyn15 pointsBadges:
  • Role of Excel/Access in SQL Server 2008 R2

    What is the role of Excel / Access in SQL Server 2008 R2?

    ITKE413,630 pointsBadges:
  • Internal vs Externa Stored Procedure Performance

    Our company develops software for Windows using C# for connecting and updating the corporate database in DB2/400. We use both internal (SQL) and external (rpg) stored procedures. Because we have noticed some bad performance in our internal stored procedures, we have the following question: Is there...

    Baron4005 pointsBadges:
  • Do Businesses still need SQL Server?

    With all the upgrades to MySQL, has SQLServer needed to step up its game or do you think business still needs SQLServer?

    ITKE413,630 pointsBadges:
  • DB2 image copy that is no longer in SYSCOPY on zOS operating system

    We have a tablespace that needs to be restored from an image copy which we have the problem is the image copy is not recorded in SYSCOPY. We also tried doing a UNLOAD FROMCOPY thinking if we got the data out of the image copy we would be able to load it back into the table. That also failed with...

    EPPERSON5 pointsBadges:
  • Transposing data in Access table

    I have a Access table with 2 cols - Mothers Name and Childrens Date of Birth. Table contains about 20k records and Mothers Name is repeated for as many children she has (i.e., Mary, 03/09/1992, Mary 05/21/1996, Mary, 12/13/2002). My goal is to have an Excel spreadsheet with cols as Mothers Name,...

    Dcathib5 pointsBadges:
  • Error when trying to drop a table that doesn’t exist in RUNSQLSTM

    If I try and DROP a table that does not exist the RUNSQLSTM will fail. Is it possible to monitor for this in the RUNSQLSTM so it won't fail?

    Gingertosser10 pointsBadges:
  • AS400 ODCB table link

    When i link tables with a ODBC driver then some table won't give me any records (I link into microsoft access. But I do see the column headings. I the record fields I get: #Name? Is this an AS400 problem, ODCB or Access ?

    Davidfromnetherlands15 pointsBadges:
  • User Files

    How do I copy user rights and access priveleges from one as/400 to another and still have access to both systems?

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

Thanks! We'll email you when relevant content is added and updated.

Following