C/EXEC SQL C+ INSERT INTO SERIOVR60 C+ SELECT HTSERN, HTPART, HTQTY, HTSTKL, C+ HTSTS, HTADAT, C+ substr(HTPART, 1, 11) AS HTMODEL, C+ HTADAT – :CURDATE AS HTDAYS C+ FROM SERI C+ WHERE HTADAT < :TESTDATE and C+ HTADAT <> ’0001-01-01′ and C+ HTSTS = ‘A’ C+ ORDER BY HTPART C/END-EXEC This returns; Date = 2010-05-12 Days [...]
Answer Question | November 13, 2010 5:07 PM
AS/400, Embedded SQL, SQL, SQLRPGLE
We’re a large TSM shop. But we also have a large distributed environment where we’ve recently implemented EMC’s Avamar backup solution. We’re now being asked to look at the TCO of replacing TSM with Avamar in our datacenter environment. We’re only looking at our VMware and NAS areas right now. My question is, who out there has any [...]
Answer Question | November 19, 2010 4:49 PM
AIX, Avamar, Backup and Recovery, Backup and recovery software, Data Center in 2010, Data Center management, EMC, Linux, TSM Backup
I have two databases A and B both are web enabled. On the menu of db A database I have a field called search that has type a head features. I can search and find the tite to display from db B but since the document is in the db B I am not able to display [...]
Answer Question | November 11, 2010 4:46 PM
Domino 7.0.2, Domino Designer, Domino Web, Lotus Domino
I would like to know how am i going to copy a certain range (A1:E500) in File A and paste it in a different file (File B). Then copy a new range in other sheet of File A then paste it in File B without overlapping the data I copied from the first range. Thank you [...]
Answer Question | November 16, 2010 4:08 PM
Excel 2003, Excel VBA, VBA, VBA EXCEL 2003
Join us on November 30 from 10am-1pm EDT for [strong]Transitioning to LTE: Business and Technical Considerations[/strong]. The goal of this interactive session around LTE business consulting is to help you consider what needs to be done as you create and implement a highly adaptive business model with customer-focused strategic planning, service mapping, cost modeling and [...]
Answer Question | November 11, 2010 3:50 PM
Live Chat, Networking, Telecom 4G LTE, VoIP
I have an Cisco ASA with one external IP address, and 2 VPN Peers. Now i need to add a web server to the mix. Please tell me how can i accomplish this bearing in mind my existing setup? Thanks,
Answer Question | November 12, 2010 3:39 PM
Cisco ASA, Cisco ASA 5510, DMZ, DMZ Switch, Web servers
same mail id configured on 20 number of client system(using exchange server) the default mail delivery is mail box server in all client. not able to open mails all users in same time there is showing error as set of folder could not open? or exchange server not avaialbe? but if any one of user [...]
Answer Question | November 12, 2010 3:30 PM
Exchange, Outlook 2003, Outlook 2003 error messages, Outlook Errors, Outlook folders, Windows XP clients
Hi, I have to create a file to send to another location outside of our company. they ask if the file type is ASCII or EBCDIC. How do I tell what the file is on the iseries? Also when I transfer the file thru FTP do I need to define it in FTP. Thanks!
Answer Question | November 16, 2010 3:22 PM
ASCII, ASCII File, EBCDIC, File Types, iSeries, iSeries File Members
hi , i’m having about 80 switches type 3400-TS on a few rings topology. i devided the rings to 10 switches per ring. could they all conncet to one 3400-CS ,working with RSTP ? or MSTP ?
Answer Question | February 16, 2011 2:05 PM
Cisco 3400, RSTP, Switches
Would like to configure ISA 2006 which i installed on Server 2003 .. so that it can acts as an firewall and control internet surfing ?
Answer Question | November 11, 2010 2:04 PM
Configuring ISA 2006, Firewalls, ISA 2006, Windows Server 2003
Is it possible to link the incoming Webmail messages to also show up in my personal Yahoo email account? This would eliminate me having to log into the webmail account and check the messages everyday.
Answer Question | November 12, 2010 12:46 PM
Email management, Email management systems, Webmail, Yahoo, Yahoo Mail
RAM of an iSeries machine… command?
Answer Question | November 12, 2010 12:36 PM
AS/400, iSeries, iSeries Commands, Random Access
How do I pass on user information to the printer from the AS/400? That is, if I wanted to embed user and job information on the IPDS job and send it to the printer, how would I go about it?
Answer Question | November 12, 2010 12:27 PM
AS/400, IBM, IPDS, iSeries, V6R1
Why does my ABG antivirus conflict with Yahoo and what should I do?
Answer Question | November 13, 2010 12:14 PM
Antivirus, AVG, AVG AntiVirus Free Edition, Software conflicts, Yahoo
How do i install Domino Administrator client on notes 8.5.1
Answer Question | November 11, 2010 11:52 AM
Domino Administrator, Domino Administrator client, Lotus Domino installation, Lotus Notes, Lotus Notes 8.5.1
I installed Oracle database 10g Express edition successfully and While installing it asked password only. But now it is asking User Name and Password. i know password but i dint gave any username. what it might be.
Answer Question | November 11, 2010 11:31 AM
Oracle administration, Oracle Database, Oracle Database 10g, Oracle User Profiles
Hi, I downloaded Oracle Database 10g Express Edition from Oracle site and i successfully installed in my system but while login i showed an error like “could not establish connection by network card” Please suggest me “how to install it”.
Answer Question | June 11, 2011 11:09 AM
Oracle 10g, Oracle Database 10g, Oracle Developer 10g Express Edition, Oracle installation
When I import a DB2 z/OS query result containing date or date(timestamp) columns from QMF for WINDOWS in EXCEL 2003 using the Add-in the cells cannot be formatted. In the same column the date are displayed sometimes as dd/mm/yyyy, sometimes as nnnnn or in the previously defined format (example dd-month ) if exists. The first [...]
Answer Question | December 20, 2010 10:56 AM
DB2, Excel 2003, Excel 2003 formulas, QMF, QMF V8, Windows XP SP2, z/OS
Hi, I am trying to convert EBCDIC to ASCII. The code which I used is converting the whole stream to ASCII however I am getting “????” for the missing characters..Is that because of double byte character set?? Can someone help me to resolve this issue??. I tried with jon-skeet code as well but facing the same [...]
Answer Question | August 27, 2011 10:03 AM
ASCII, C#, EBCDIC
i want to know how to implement an internal mailing system using ASP.NET and Oracle Database.
Answer Question | November 11, 2010 9:08 AM
ASP.NET, ASP.NET Web applications, Oracle Database, Oracle database design