• Need help executing MULTIPLE SQL extracts from a JCL

    GREYBEARD52: Thanks again for the info, BUT I'm not sure if a CL command can be used with a JCL. Can it? ALSO, my JCL uses the SELECT command, so it appears that the RUNSQLSTM command won't help - it doesn't support SELECT. Are there ANY OTHER ALTERNATIVES or a way to tweek this command to 1. Run...

    Jonty Walker105 pointsBadges:
  • Why does the keyword END is not accepted at the end of a stored proc ?

    Hey guys,  I have thise error in SQL stored proc.  I'm on ISERIES and I use RUNSQLSTM to very my procedure. could you help ?  It's seem I can't put a END at the end! ---------------------     160            AND DUDGCT =...

    FRANKIA5 pointsBadges:
  • sql query

    Hi my quation is .. [em]i had a tablecalled product. it has some fields like P_ID,PNAME,SALES,DATE etc write a quary to display the sales less than 100$ only[/em] 

    12a5 pointsBadges:
  • PICTURE STORE IN ACCESS 2007 DATABASE THROUGH VB

    KINDLY TELL ME HOW I STORE PICTURE/IMAGE IN ACCESS 2007 DATABASE THROUGH VB CODE     ANANDA DEBNATH INDIA, DELHI  

    AnandaDebnath280 pointsBadges:
  • COMBO BOX (IN VB) HOW BEHAVE LIKE MS ACCESS

    HI VB EXPERTS, PLEASE SOLVE HOW CAN BEHAVE THE VB COMBO JUST LIKE MS ACCESS COMBO (OFFICE 2003/2007) EG. IN MS ACCESS COMBO :- A) WHEN START TYPING THEN NEAREST MATCHED SELECTED/DISPLAYED B) ON GOT FOCUS COMBO DROPDOWN ABOVE FACILITIES I WISH TO AVAIL IN VB COMBO BOX PLEASE PLEASE PLEASE SOLVE IT...

    AnandaDebnath280 pointsBadges:
  • Migration from Paradox to MS Access or VB.Net/MS SQL

    We have a department that has several applications running on Paradox 11.  They need assistance migrating their tables and application UI/code to another platform.  Any feedback or guidance would be appreciated.

    ScotE45 pointsBadges:
  • Constraints (MySql,tables,null,PK,FK etc)

    Hi all(waves) noob here ( :) ) ( yes you might look down upon me) ( :( ) never the less....:)  Quick question: Tables made so far: department values (depno,dname) course values values (courseno) How would I create a table eg "Table budgets"...with values of two budgets (£100 and £200) for...

    Ak1bo78150 pointsBadges:
  • PHP and MS Access Database

    I'm trying to access an access databse located in my LAN thru php. When I run the script, I get the below error in Apache's error log file: "[strong]PHP Fatal error: Uncaught exception 'com_exception' with message 'Source: Microsoft OLE DB Provider for ODBC Drivers Description: Operation was...

    TCF5 pointsBadges:
  • How do I place duplicate directly below the copied record?

    I have code (below) which works perfectly today attached to a button to copy a record in a form. But, it inserts the new record at the bottom of the form, I would like to make it past the new record immediately below the copied record. Is there a way to do this? Private Sub Duplicate_Record_Click()...

    Klemieux5 pointsBadges:
  • Client Access Data Transfer

    I am trying to export a demand report to excel using Client Access Data Transfer. The demand report has been saved in the outque (see below). From what I understand the data to and from the iSeries must be either a database table or source physical file. How do I convert the saved report to a...

    Joe9250610 pointsBadges:
  • can anybody tell me how to know max sal in db2/400 means in pf

    can anybody tell me how to know max sal in db2/400 means in pf

    Siru15 pointsBadges:
  • SQL to insert comma-delimited string value to table column

    I have string like '1,2,3,45,6,7,8' I want to insert each comma separated value in a table column...my output look like this: COLUMN 1 2 3 45 6 7 8

    231219835 pointsBadges:
  • Bluetooth History List/Device List

    How to tabulate (say in excell spreadsheet or better in Access databases table.) all slaves Bluetooth devices of Master Bluetooth device (in my case Laptop)? I have to refresh Bluetooth devices (F5) at fixed interval of say every minute as in my Access application a Macro is activated at interval...

    Apcalogic50 pointsBadges:
  • Domino server R7 and DB2

    Hi all, I would like to setup a Domino 7 server and DB2. Our environment has experience seperate server for Domino 7 and DB2 server. Does anyone know that is tht possible to install Domino 7 server and DB2 into one single powerful server? Kindly advise. Thank you.

    R7130 pointsBadges:
  • what is different from MSSQL, MYSQL and Oracle 11g?

    what is different from MSSQL, MYSQL and Oracle 11g? Which one is the best for 15000 transaction daily?

    Juna060615 pointsBadges:
  • GAMBAS – as front-end of open dbase?

    hi..greetings to all i am an IT student and i am here to seek help. I am using UNIX OS. edubuntu v9 to be specific. and we ar eought to make a databe having gambas(if your familira wiht it) as front and dbase as the physical storage..how is this possible. last year we created a mini-database using...

    Cookie726315 pointsBadges:
  • Query Regarding Crystal Reports

    Hi, I need to produce a flat file in fixed length format as output of Crystal Report. Wanted to know if crystal report supports exporting data into a Flat file fixed lenght format. If yes, would like to know how to go about it.

    Vabene0 pointsBadges:
  • Setup project force new file replacement on reinstall

    Hello, I have a setup project that install a couple of projects and a couple of external files (one of which is a SQLite Database) - everything worked fine until i've recently modified the base database file included in the setup project. Now, every time i try to reinstall the project the new...

    Trutas25 pointsBadges:
  • cisco access point

    Dear all, network scenario: we have 3 core switches.STP root bridge for vlan 80 and vlan 61 is core 3 switch problem: when traceroute from vlan 50 to vlan 80 I can traceroute to vlan 80 clients but not for vlan 80 default gateway. for vlan 80 default gateway is core 1 192.168.21.252, core2 is...

    Ekansh400 pointsBadges:
  • Optimizing/Indexing to find last transaction

    I'm hoping someone can help me out with this. I'm trying to write a query that will return the last transaction for each item in our warehouse. To do this, I'm using 2 files, first our location detail which has a list of all the locations in our warehouse. This file only has about 60,000 records,...

    MODMOD0 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