-
Good day, We are using Windows 2000 Small Business Server in our organization with Exchange, DNS and ISA server configured. 1. I want to monitor the internet usage by the users. 2. I want to take a report on monthly or daily basis how much MB/GB utilized by each user. Thanks for your reply in...
Last updated: -
The numeric field in my table is left justified and works fine but any queries I use with that field end up being right justified. Is there a simple fix for this.
Last updated: -
I have an address field with a 6 digit zero fill street address. eg, 1032 is 001032. I need to eliminate only the leading zeros.
Last updated: -
Dynamic Case Management Open Source
What's the best DCM software or library open source to implement in a php and MySQL project?
-
What is wrong with this function:=DateAdd('d','20',[REFERRAL]) I am adding 20 days to the Input date "Referral date" label . The message I get back when I save is that it cannot find REFERRAL? This function is in the Default Value for the date I want to change (Audit Date)
Last updated: -
Copy data from one mainframe to another
Hi everyone, I'm a complete newcomer to the mainframe world, and have been tasked with writing some procedures to copy data (not just files, but directories... PDS I think its called?) from one mainframe to another. I've researched it a bit, and it seems that FTP is probably the best way to go...
Last updated: -
Where SQL statement is open ended
Is it possible to have a where SQL statement that is open ended. I have notice that there are time that parameter box pops up with some the Access pass-through queries that I have. Is it possible with SQL to be able to have a box pop up that would ask for a specific input to the...
Last updated: -
Cisco Access Point: Wireless client is disconnected
We have 21 Access Point in field in our company location. all are working and having the Good configuration along with channels and security authentication. But now a days we are facing problem with 3 access points where wireless client in one VLAN is not associating and there is no problem in...
Last updated: -
Access database 10 date change
I want to change a date by 20 days each time a new date is entered. I'm using Access Database 10. I have an input date that I want to increase by 20 days and show that new date each time an input date is generated..
Last updated: -
Application and database monitoring tool
Which monitoring tool is the best tool for application and database monitoring?
Last updated: -
Deleted user profiles in AS/400
Hi Is there any way we can know about deleted user profiles in AS/400? We have an audit process wherein the auditor have asked for a list of all the users deleted. Can any one suggest where can I get such a list? pgsdeb
Last updated: -
Add a field in existing file in DB2/400
I need add a field in existing Physical file without impacting any other file? I know the CHGPF command but I'm not sure about which parameter needs to be update. Please advice.
Last updated: -
Transfer data from DB2 file to SQL Server file
I want to transfer a data from a DB2 file to a SQL Server file. I do not want to buy a software that do it. I want to do it by myself (perhaps using ODBC) Thanks all for help. Abdou
Last updated: -
DB2 (AS/400) data transfer to SQL Server 2005
How do I do a Data transfer from DB2 (AS400) TO SQL SERVER 2005?
Last updated: -
Call a webservice from stored procedure
Looking for a suggestion. I have web service that sends order data to an iSeries to be processed. The order may or may not be created based on the data validation on the I-Series side. If it is successful the order gets created. My problem is trying to add additional data (order notes) on a...
Last updated: -
Connection between CDR files and the corresponding database files
If I knew the CDR file name and I want to match it with the corresponding database file name, for example I have this CDR file name (VT032013061200022234). Which file of the coming database file name it match...
-
Hi I am 47 years old. Can I be DBA specialist? My entire career I was QA specialist. Now I am tired of it. Can I change my career? What is the best option for me?
Last updated: -
File in external datastructure
Will level check occur on program when you changed the file mentioned in external data structure?
Last updated: -
DB2 WebQuery for System i problem
Hi! Our server has already installed with DB2 web query. I have checked the basic things in licensed programs like QWEBQRC77(*lib) , MRADMIN(*usrprf)...everything is there. But when I try to start web query, the command is not available and also in license programs the web query shown like...
Last updated: -
AS/400-DDL: Create table command
I have created table using CREATE TABLE command. I want to see the source of table. Is there a possibility to view the table's source in AS/400
Last updated: