DB2 physical file

how we can create View with Key to more than one PF in Diffrance Lib exsample LIB                         PF File Name ============================= Lib1                         Custom             (( for HeadOffice ))...

Hodish40635 pointsBadges:

Infinite recursion in SQL Server 2000

consider a recursive query in SQL.How to handle infinite recursion to make the query evaluation optimized?

Gomsbk35 pointsBadges:

Best Database Management System Out in the Market

I would just like to ask what the best database management system is right now? Especially for a new company or business. Just really something easy for endusers. What will you recommend for me? Thank You! 

Abenito10 pointsBadges:

Backup/recovery across multiple schema

What is the best strategy for backup/recovery of multiple schemas in a database

Backup105 pointsBadges:

How do I create a trigger in VB 6?

HOW TO CREATE A TRIGGER IN VB6

AnandaDebnath280 pointsBadges:

When setting up a cluster for failover purposes do you only inclde hardware of one vendor?

When setting up a cluster for the purpose of failover do you only include in that cluster servers made by the same vendor or can you mix vendors? 

Jim4522820 pointsBadges:

Operating DOS through excel(VB or macro).

Cheers. I m new to IT.I wish 2 operate DOS through excel. For example , in DOS we write some command and then press enter, then dos displays the information concerned with that command. Is this possible to do this, i.e writing command in DOS and pressing enter jst by writing a programme in...

Begginer65 pointsBadges:

web-based GPS tracking application development with asp.net

i'm a final year degree student majoring in network computing.  i'm developing a GPS related web application where data is being taken from a gps tracker (TK-102), which can send data to a ip address and port number defined. there for i need to save this data to a database and then represent it on...

Veriya30 pointsBadges:

Trying to Design a Split Database Access 2007/SQL Server Express

Hi, This post will be long, as I have several questions related to this project, but please feel free to only answer any piece you want, however small. Every bit of knowledge will be helpful. One of the programs at my office is in need of a database. I've been researching this for awhile, and going...

Dataempress115 pointsBadges:

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:

Exporting Active Directory user info to CSV

Can we export all of our AD data to a CSV file for backup purposes? Can we export the passwords as well? Will they  be encrypted? Where can we find the encryption key so we can make heads or tales of them.

Karl Gechlik9,860 pointsBadges:

Access 2003 – command button to show query in pivot format

I have a form with a comman button.  I want the user to be brought to a query when they press the button.  The query is built in a pivot table format, but when accessed by the command button, it appears as a datatable instead.  What am I doing wrong?

Smbecker5 pointsBadges:

job QZDASOINIT

My web application is using ODBC connection to access DB2.Connections are closed properly on each page.But job QZDASOINIT is not ending and remain in TIMW status.This is creating large number of jobs on server.How can i close this job when connection is closed?

Wasifzaheer35 pointsBadges:

Windows go blank while running reports in 10g

I have oracle 10g as the database and front-end. When I run my application in 2 different windows and run a report in one of the windows, the other goes blank until the report is finished running. Any ideas why? Appreciate your help.

Freestyler10985 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:

Jreport problem – floating point literal

hi! I'm new here! I have a report and this is connect to db2/as400. When I compile i have the next error "[SQL0410] Floating point literal 2.00805121133377101E18 not valid. Cause...." I don't know what is happenning. The query I run in other program and this is right, so I think is something with...

LouIT5 pointsBadges:

Expression Builder, Calculation confusion in Access 2007

Ok I’m having trouble with this simple calculation.  I have a Query with a field called “% of fire Calls made” it may contain a number (ie 23.34). I’ve tried to create another field in the same query that ask the question, if the # in “% of fire Calls made” is equal to or greater than...

Phil12550120 pointsBadges:

Translate Ruby Script to SQL Query?

I need help translating a ruby script to SQL query. I'm a SQL noob. Help please. [em]here is the script.[/em] require "rubygems" require "ruport" SQL = <<-EOS SELECT     tv.ApptDate, tv.PatName, tv.PatFirst, tv.PatLast, tv.Phone, tv.ApptTime, tv.Provlast, tv.ProvFirst, tv.ProvTitle,...

Transom3245 pointsBadges:

Excel date format

I am trying to copy data from one of our systems into Excel. Everything copies into Excel except the dates. My source data date format is MMM DD, YYYY (example Jul 14, 2004). I have tried changing the Excel from general to text and also tried changing the date formats.

Tamara5 pointsBadges:

ID Theft and National Security

If it turns out, as I believe, that enemies of the United States are behind a lot of the major ID thefts in the US, that would mean that a lot of money is going to our enemies. Can we therefore surmise that those who mishandle our identity information, by means of their poor stewardship of our...

InfoSafety75 pointsBadges: