• Embedded SQL in RPGLE

    I am trying to get some counts and totals from one file and put them in another. My SQL statement works fine with STRSQL, not in the RPGLE. Do I have to declare/set a cursor, exec sql and close the cursor just to put the total in another file? C/EXEC SQL C+ INSERT INTO outputfile C+ SELECT...

    Nickhutcheson165 pointsBadges:
  • Using SELECT with LIMIT clause on a physical file

    Hi - I'm new to PHP & SQL and wanted to know if you can use mysql SELECT with the LIMIT clause on a iseries physical file in order to do pagination. Thanks for the help.

    jakusza30 pointsBadges:
  • PHP functions

    how do multiple functions work

    SGB35 pointsBadges:
  • tutorials

    hi all. i wanted to ask if anyone knows any sites where i can download free ebooks or free tutorials. thx.

    Mmm5550 pointsBadges:
  • Connect to remote SQL server from MySQL

    we have read only access to a remote sql server. the requirement is to read few tables from sql server and load to mysql tables (installed on Unix box). Please suggest the possible ways of achieving this.

    Nitibansal5 pointsBadges:
  • error in SQL workbench

    ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2 SQL Statement: CREATE  TABLE `cape codd`.`SKU_DATA` ( )   Does anyone know how to fix or workaround this? thanks Whitney Ferrante

    Whitneyf5 pointsBadges:
  • Migrating Access Tables in MYSQL Server using MYSQL Server Enterprise Manager

    Can someone please help me in migrating my tables form Access to MYSQL Server Enterprise Manager

    Anco5 pointsBadges:
  • pagination using MySql

    can anybody get any query for pagination using MySql.. any helps are welcome

    NetDeveloper90 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • Sql Query For My sql

    I have two database tables Employee and salary    Where Employee maintains details about employee And the salary table maintains data about Payroll entry.             Iwant the query for Select the employees who have not got salary for a particular month I have already tried this...

    MargraveMathan10 pointsBadges:
  • MySQL brain teaser

    This has been driving me crazy. I’m trying to come up with an UPDATE query in MySQL that will remove the second blank space in a name and close the gap.   Example: O Brien, John E should become OBrien, John E   A simple REPLACE (name, ‘ ‘,’’) where SUBSTRING (name,2,1) like “ “...

    Michael Morisy8,323 pointsBadges:
  • help me create trigger update column

    CREATE  TRIGGER Trigger_UPDATE_BIENLAI_TIENNOP ON BIENLAI FOR UPDATE,INSERT,DELETE AS IF (@@ROWCOUNT = 0) BEGIN PRINT ' TABLE is null' RETURN END IF UPDATE(TIENNOP) BEGIN UPDATE BL1 SET BL1.TIENNOP = BL3.TIENNOP FROM BIENLAI BL1,DELETED BL2,INSERTED BL3  WHERE BL1.SOBL = BL2.SOBL AND (BL3.TIENNOP...

    2110805 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:
  • 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?

    ITKE352,485 pointsBadges:
  • SQL query

    I have two database tables of employee where employee table maintains EMPNO,ENAME,JOB,MANAGER,HIREDATE,SALARY,COMMISION ,DEPTNO and department table maintais details of DEPTNO,DNAME,LOCATION. questions are : 1)Display the first four rows of employee table. 2)Display the empno,ename from row 2 to...

    Srividya5 pointsBadges:
  • mysqldatetime exception

    mysqldatetime exception i am using MySql  with c# in my window application , In code i think everything is fine , when i made a latest patch for the given installer it throwing an exceptuon at client side " Cannot perform '<=' operation on MySql.Data.Types.MySqlDateTime and System.String." when...

    ITKE352,485 pointsBadges:
  • passing array as parameter to stored procedure in mysql

    how to passing array as parameter to stored procedure in mysql?

    Itprofession5 pointsBadges:
  • MySQLi and PHP problem with code

    Can someone please tell me what I'm doing wrong with this particular line of code. echo "<td colspan=3>{$Row['areaCode'] . '-' . $Row['prefix'] . '-' . $Row['lineNumber']}</td></tr>"; I know that the concatenation operator is the . 'areaCode' 'prefix' and 'lineNumber' are all...

    PatOswalt115 pointsBadges:
  • php and mysql

    How can we create a family tree map using php and mysql?

    Sanasher5 pointsBadges:
  • Ajax based multiserver GUI for MySQL?

    I am looking for Web 2.0 product that allows me to manage multiple MySQL servers at the same time. I did found one proct that seem to do the job, but I would like to compare it with some other ones! (the product is located at http://novaquantum.com )

    Mysqldba5 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