DB2 (Oracle funtionality in)

Hi, all I have no familiarity with DB2, but plenty in Oracle and SQL Server and other RDMS. In Oracle, I can access a flat file on disk by defining it as an External File. Similar functionality in SQL Server. My question then: Does DB@ on the mainframe have the same type of feature? Thanks in...

Rireland5 pointsBadges:

Mainframe – Someone moving my DB2 Object to READ ONLY

How to know who is or which application moving my TS to READ ONLY in a z/OS environment?  

Geetika12315 pointsBadges:

SQL for MS Access Syntex issue

I have started to read the book by Cecelia L. Allison and Neal A Berkowitz on SQL for Microsoft Access.  and there is a syntex listed below that has been giving me a problem.   I get an error with the word UNIQUE.  So I removed it from the statement and then I get an error with the ON section...

CompEng1,240 pointsBadges:

How do I transfer 300 gigs of information?? Please Help!!

I am using roadkil unstoppable copier and my transfer always stops halfway, am I doing it wrong or what!!! I'm transferring 13 300gig drives to a 4T hub. The hub is Western Digital 4T Sharespace and I have to connect to it via network, it doesn't work with usb to usb. I thought that unstoppable...

Joeyjoejoe30 pointsBadges:

The most-watched IT questions this week: Feb. 2, 2010

Tick tock, tick tock. What’s that sound?  The countdown for the Nexus One Challenge. What? You’ve moved on? Well

Michael Morisy8,643 pointsBadges:

setting up cisco ACS SE

Dear All, I'm trying to install an ACS Solution Engine in My network for access control (AAA). I succeed in setting up authentication using the internal database and that works. now My boss want users to be authenticated through an external database (windows AD). I tried achieving this but kept...

Vwarhe5 pointsBadges:

db2 to excel

i was tryin to import from db2/400 into excel but when i did. the description came up in a different language...in db2/400 the description was in araic then when i imported in excel it came up a different language?? any idea plz help  thank you

Doodoo5 pointsBadges:

DECFLOAT – Internal Format

Hello, How to translate an internal DECFLOAT value into a visual format? DB2 Administration Guide: "Convert and return a DECFLOAT representation of a number or string representation of a number", (Appendix A. Writing exit routines). There is an example there: Internal...

Eligin20 pointsBadges:

Different results for embedded SQL

I have embedded SQL in my RPG code and some of the results are different to what I get when I check using STRSQL

Macitmich20 pointsBadges:

DB2/400 Error Trapping

how to trap error in dds ie.., db2400 

Gchakradhar15 pointsBadges:

Access 2007 form creation

Hi There, I have created a transport database for my organisation where employees can req for transport when needed. But i'm not good at Access 2007. I need help on below list of queries: 1. I have created button for employees to submit their request, now when they click on that button a message...

Kvs35 pointsBadges:

Access 2007 form creation

[strong]KVS: [/strong] [strong]Q: [/strong]Hi There, I have created a transport database for my organisation where employees can req for transport when needed. But i'm not good at Access 2007. I need help on below list of queries: 1. I have created button for employees to submit their request, now...

Kvs35 pointsBadges:

connectivy between C++ and MS Access

hi, i have problem releted with ms acess and c++ programming languge sir cant get any information about connection between ms acess and c++ programming languge give me steps to connect ms acess and c++

AMOL1210 pointsBadges:

multiple records update in single query with where class

Hi I am doing one project using (Vb6.0 + ms-access) I have two tables [Br style="outline-style: none; outline-width: initial; outline-color: initial;" /> [Br style="outline-style: none; outline-width: initial; outline-color: initial;" /> 1.segment-Table:[Br style="outline-style: none;...

Srbatcha10 pointsBadges:

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: