IBMDA400 Date Issues
The IBMDA400 provider seems to convert dates to character values even when using keyword “Convert Date Time To Char=FALSE”. This does not happen with the ODBC driver or IBMDASQL provider. I’d be okay with IBMDASQL except IBM states it only works the SQL statements. I’d be okay with ODBC driver except records can be doubled [...]
Answer Question
| December 18, 2012 4:33 PM
AS/400, iSeries, ODBC
The IBMDA400 provider seems to convert dates to character values even when using keyword “Convert Date Time To Char=FALSE”. This does not happen with the ODBC driver or IBMDASQL provider. I’d be okay with IBMDASQL except IBM states it only works the SQL statements. I’d be okay with ODBC driver except records can be doubled [...]
Answer Question
| December 18, 2012 4:33 PM
AS/400, iSeries, ODBC
Entry Level Vendor Neutral SQL Certification
Hello, Can anyone recommend an entry level vendor neutral SQL certification? I am looking for a cert that is focused on SQL coding rather than learning a specific database. I want to get into database programming and show that I know the basics such as normalization, querying, joins, etc. Thanks for your help.
Answer Question
| December 18, 2012 2:54 PM
SQL, SQL certifications
Hello, Can anyone recommend an entry level vendor neutral SQL certification? I am looking for a cert that is focused on SQL coding rather than learning a specific database. I want to get into database programming and show that I know the basics such as normalization, querying, joins, etc. Thanks for your help.
Answer Question
| December 18, 2012 2:54 PM
SQL, SQL certifications
Terminated Users in AS/400 system.
Hi is there any way or any command to find the list of terminated users from an AS400 system for a particular time period…?
Answer Question
| December 18, 2012 2:46 PM
AS/400, AS400 admin
Hi is there any way or any command to find the list of terminated users from an AS400 system for a particular time period…?
Answer Question
| December 18, 2012 2:46 PM
AS/400, AS400 admin
Message Ids in Message File
How to check whether a msg id is moved today or when? For E.g. If MsgId UR000 is moved to MsgF SSA000 on 24 Dec 2012 and Again the same msg id needs to be moved on a particular day then how to identity the last date of its Movement? I performed the below steps:- [...]
Answer Question
| December 18, 2012 1:57 PM
AS400 admin
How to check whether a msg id is moved today or when? For E.g. If MsgId UR000 is moved to MsgF SSA000 on 24 Dec 2012 and Again the same msg id needs to be moved on a particular day then how to identity the last date of its Movement? I performed the below steps:- [...]
Answer Question
| December 18, 2012 1:57 PM
AS400 admin
How to transfer an iSeries file
How to transfer the file from one iSeries to another iSeries?
Answer Question
| December 18, 2012 11:23 AM
AS/400, iSeries, iSeries files
How to transfer the file from one iSeries to another iSeries?
Answer Question
| December 18, 2012 11:23 AM
AS/400, iSeries, iSeries files
Access to DB2 from Oracle
I want to access the DB2 database on iSeries from Oracle 11 (read and write). What is the best way?
Answer Question
| December 18, 2012 11:11 AM
DB2 database, iSeries, Oracle 11
I want to access the DB2 database on iSeries from Oracle 11 (read and write). What is the best way?
Answer Question
| December 18, 2012 11:11 AM
DB2 database, iSeries, Oracle 11
AS400 – RPGLE
FTESTCF IF E K Disk * /Free EmpNo = 100; Chain (EmpNo) TestCF; If %Found(TestCF); Dsply EmpName; Endif; Dsply EmpName; Clear RTEST; EmpNo = 101; Chain (EmpNo) TestCF; If %Found(TestCF); Dsply EmpName; Endif; Dsply EmpName; Above Code Employee NUmber 100 is found in File. Employee Name is coming as expected. But EMPNO = 101 is [...]
Answer Question
| December 18, 2012 9:18 AM
AS/400, AS400 RPGLE
FTESTCF IF E K Disk * /Free EmpNo = 100; Chain (EmpNo) TestCF; If %Found(TestCF); Dsply EmpName; Endif; Dsply EmpName; Clear RTEST; EmpNo = 101; Chain (EmpNo) TestCF; If %Found(TestCF); Dsply EmpName; Endif; Dsply EmpName; Above Code Employee NUmber 100 is found in File. Employee Name is coming as expected. But EMPNO = 101 is [...]
Answer Question
| December 18, 2012 9:18 AM
AS/400, AS400 RPGLE
Client Access
My Client Access connects when I go to create 5250 sessions for two of my LPARs,but I don’t get a sign on screen. I do get a sign on screen for two other LPARs. What needs to be checked?
Answer Question
| December 18, 2012 9:07 AM
Client Access connectivity
My Client Access connects when I go to create 5250 sessions for two of my LPARs,but I don’t get a sign on screen. I do get a sign on screen for two other LPARs. What needs to be checked?
Answer Question
| December 18, 2012 9:07 AM
Client Access connectivity
Best VoIP Vendor
Hi, I want a VoIP vendor who can provide me unlimited call for 1000 users at a time, they can make call from my web site from my dialer like “Skype” works. I am planning to create a web site where user will log in and can use my dialer to make free call on [...]
Answer Question
| December 18, 2012 8:58 AM
VoIP
Hi, I want a VoIP vendor who can provide me unlimited call for 1000 users at a time, they can make call from my web site from my dialer like “Skype” works. I am planning to create a web site where user will log in and can use my dialer to make free call on [...]
Answer Question
| December 18, 2012 8:58 AM
VoIP
Need to identify the next sequence of number in a character field in DB2
I have a scenario where I need to find the next sequence of numbers in a character field. I found the starting position by using the LOCATE command but need to find the next sequence in the same row if anything. For Example: Issue Number : 01 Card Number 1234 5678 9012 3456. I found [...]
Answer Question
| December 18, 2012 7:34 AM
AS/400 V6r1m0, DB2
I have a scenario where I need to find the next sequence of numbers in a character field. I found the starting position by using the LOCATE command but need to find the next sequence in the same row if anything. For Example: Issue Number : 01 Card Number 1234 5678 9012 3456. I found [...]
Answer Question
| December 18, 2012 7:34 AM
AS/400 V6r1m0, DB2
How to install Oracle 10g application server on Ubuntu 12.04(32-bit) server edition
I have installed Oracle 10g on Ubuntu 12.04 server edition, and now was trying to install Oracle 10g application server on same machine. But while installing I am getting some errors which I try a lot to rectify but not working fine the errors are like this: /u01/Oracle10gAS/opmn/bin/opmn: error while loading shared libraries: libclntsh.so.10.1: cannot [...]
Answer Question
| December 18, 2012 5:47 AM
Oracle 10g, Ubuntu 12.04
I have installed Oracle 10g on Ubuntu 12.04 server edition, and now was trying to install Oracle 10g application server on same machine. But while installing I am getting some errors which I try a lot to rectify but not working fine the errors are like this: /u01/Oracle10gAS/opmn/bin/opmn: error while loading shared libraries: libclntsh.so.10.1: cannot [...]
Answer Question
| December 18, 2012 5:47 AM
Oracle 10g, Ubuntu 12.04
How to set searches within Excel to default always to the top row
I want “Find and Replace” search result Excel row to always rise to the top of the page when I make a search window inquiry. It seems to only rise to the top of the page if the “find and replace” inquiry RESULT is not already visible on the existing viewing page. If it IS [...]
Answer Question
| December 18, 2012 4:21 AM
Microsoft Excel 2003
I want “Find and Replace” search result Excel row to always rise to the top of the page when I make a search window inquiry. It seems to only rise to the top of the page if the “find and replace” inquiry RESULT is not already visible on the existing viewing page. If it IS [...]
Answer Question
| December 18, 2012 4:21 AM
Microsoft Excel 2003
Using rule to forward meeting request in Outlook
We just switched over to Outlook 2010. I set up a rule to forward meeting invites to my personal email in order to keep my calendars in synch. “Apply this rule after the message arrives which is a meeting invitation or update forward it except if from . When I try to accept the forwarded [...]
Answer Question
| December 18, 2012 11:23 PM
Microsoft Outlook 2010, Microsoft Outlook meetings
We just switched over to Outlook 2010. I set up a rule to forward meeting invites to my personal email in order to keep my calendars in synch. “Apply this rule after the message arrives which is a meeting invitation or update forward it except if from . When I try to accept the forwarded [...]
Answer Question
| December 18, 2012 11:23 PM
Microsoft Outlook 2010, Microsoft Outlook meetings
Having trouble creating a Client Access session using VBA \
We have numerous Excel Based Interface Macros that Create Client Access sessions, but none will work with Excel 2010.
Answer Question
| December 18, 2012 9:28 PM
Client Access 6.1, Microsoft Excel 2010
We have numerous Excel Based Interface Macros that Create Client Access sessions, but none will work with Excel 2010.
Answer Question
| December 18, 2012 9:28 PM
Client Access 6.1, Microsoft Excel 2010
What was the biggest technology story of 2012?
2012 was an interesting year for technology, as we saw several new innovations (Windows 8/iPhone 5) as well as on-going feuds (Apple vs. Samsung). Tell us what you think was the biggest technology story of 2012.
Answer Question
| January 7, 2013 8:06 PM
Apple, iPhone 5, samsung, Technology, Windows 8
2012 was an interesting year for technology, as we saw several new innovations (Windows 8/iPhone 5) as well as on-going feuds (Apple vs. Samsung). Tell us what you think was the biggest technology story of 2012.
Answer Question
| January 7, 2013 8:06 PM
Apple, iPhone 5, samsung, Technology, Windows 8
Exchange 2010 Published calendar not updating
Hi all, We are looking to move our organization over from Google Calendars to Exchange calendars. Because we have a mixed environment (mostly Macs using Mac Mail/iCal and Outlook 2011, as well as Outlook 2010 on the PC side), the only way to get the calendar to automatically appear within each Calendar client is to [...]
Answer Question
| December 17, 2012 6:40 PM
Microsoft Exchange 2010, Microsoft Exchange calendar
Hi all, We are looking to move our organization over from Google Calendars to Exchange calendars. Because we have a mixed environment (mostly Macs using Mac Mail/iCal and Outlook 2011, as well as Outlook 2010 on the PC side), the only way to get the calendar to automatically appear within each Calendar client is to [...]
Answer Question
| December 17, 2012 6:40 PM
Microsoft Exchange 2010, Microsoft Exchange calendar
EU security directive
Where can I find implementation details for complying with EU directive 95/46/ec?
Answer Question
| December 17, 2012 4:29 PM
EU directive 95/46
Where can I find implementation details for complying with EU directive 95/46/ec?
Answer Question
| December 17, 2012 4:29 PM
EU directive 95/46
2950 Access Problem
I cannot ssh to the switch from outside of the VLAN. I cannot ssh or anything (connect) to devices connected to each port. the devices are able to get out to the internet fine. I’m missing something. Please help. I know I should have configured everything on Vlan1 but did not. I have fa0/1 which [...]
Answer Question
| December 17, 2012 12:53 PM
Cisco 2950, SSH, VLAN
I cannot ssh to the switch from outside of the VLAN. I cannot ssh or anything (connect) to devices connected to each port. the devices are able to get out to the internet fine. I’m missing something. Please help. I know I should have configured everything on Vlan1 but did not. I have fa0/1 which [...]
Answer Question
| December 17, 2012 12:53 PM
Cisco 2950, SSH, VLAN
CACHE.. using safari, on my apple mac book air
I no longer have a cache, have tried to reload browser,not happening. Please give me some pointers…..do not know where to look, I really need this cache emptied.
Answer Question
| December 17, 2012 11:30 AM
Cache
I no longer have a cache, have tried to reload browser,not happening. Please give me some pointers…..do not know where to look, I really need this cache emptied.
Answer Question
| December 17, 2012 11:30 AM
Cache
Tutorial questions and answers
Queries on Oracle database black screen?
Answer Question
| December 17, 2012 11:07 AM
Oracle, Oracle Database
Queries on Oracle database black screen?
Answer Question
| December 17, 2012 11:07 AM
Oracle, Oracle Database
