• 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:
  • AS400 ODBC

    Hi Our company uses AS400 for our financial processing application. The users access the AS400 through an emulator. They also access the application database through ODBC. They extract the data to excel sheets to create certain reports for their own purpose. Recently, one the data base files in...

    Pgsdeb20 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:
  • Need to know equipment needed to setup a simple network to share DB

    Hello, I am not into networking but I like to try new things. I am setting up a simple network of about 12 computers to share an access database. The site is remote so there is no internet access at this time. We should however have internet access ina few months. I need a list of the...

    Jerbro5 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 data over web browser

    Our solutions resides in System i and its all are internal developed systems. Our applications are Logistics business driven and now we have the need to publish these informations over web for view by customers. HOW do i do that.. and what should i consider..

    bsathia20 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 Replace Text in a table

    Is there a statement I can add that will automatically replace a text string with another string? EX> NORTH CHANGE TO BILLY BOB THROUGH OUT A FIELD

    Dapostman5 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?

    ITKE342,240 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?

    ITKE342,240 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:

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