AS/400
I tried commitment control for that I created file salary dds is as follow A R RSALARY A NAME 10 A SURNAME 10 A SAL 10 0 created one disply file for that dds is as follow A*%%TS SD 20121218 034714 KRGUNN REL-V6R1M0 5761-WDS A*%%EC A DSPSIZ(24 80 *DS3) A R RSALDSPF A*%%TS SD 20121218 [...]
Answer Question
| December 19, 2012 6:08 AM
AS/400, AS/400 commands
I tried commitment control for that I created file salary dds is as follow A R RSALARY A NAME 10 A SURNAME 10 A SAL 10 0 created one disply file for that dds is as follow A*%%TS SD 20121218 034714 KRGUNN REL-V6R1M0 5761-WDS A*%%EC A DSPSIZ(24 80 *DS3) A R RSALDSPF A*%%TS SD 20121218 [...]
Answer Question
| December 19, 2012 6:08 AM
AS/400, AS/400 commands
How to avoid MSGW in a DATA Queue
I have a Program A which sends a message to a data queue , There is a job running on the System i , which monitor this data queue , and when it receives a message in this queue a set of programs is called . The problem is when one of the programs has [...]
Answer Question
| December 19, 2012 4:35 AM
AS/400, Data Queue, MSGW
I have a Program A which sends a message to a data queue , There is a job running on the System i , which monitor this data queue , and when it receives a message in this queue a set of programs is called . The problem is when one of the programs has [...]
Answer Question
| December 19, 2012 4:35 AM
AS/400, Data Queue, MSGW
Delete the two months old log files
Hi, Basically it has to find out the two month old files by comparing the time stamp with another files according to that I have to delete the two month old files in the log folder. It has to find out the two month old log files by compare the today date.
Answer Question
| December 19, 2012 4:21 AM
Log files, Log folder
Hi, Basically it has to find out the two month old files by comparing the time stamp with another files according to that I have to delete the two month old files in the log folder. It has to find out the two month old log files by compare the today date.
Answer Question
| December 19, 2012 4:21 AM
Log files, Log folder
Turn off organiser calendar entry
2010 – how do I organize a meeting without it appearing in my calendar?
Answer Question
| December 19, 2012 3:21 AM
Microsoft Outlook, Microsoft Outlook Calendar
2010 – how do I organize a meeting without it appearing in my calendar?
Answer Question
| December 19, 2012 3:21 AM
Microsoft Outlook, Microsoft Outlook Calendar
Testing Autodiscover failed Exchange 2010
I just installed a Exchange 2010 Outlook anyware on my SBS 2008. All my user are receiving email when they are in the office with. There Cell phone are able to receive email as well. My Off site user are not able to connect to the exchange server only thru VPN. I installed SSL Cret [...]
Answer Question
| December 19, 2012 3:04 AM
Microsoft Exchange 2010, Microsoft Exchange errors
I just installed a Exchange 2010 Outlook anyware on my SBS 2008. All my user are receiving email when they are in the office with. There Cell phone are able to receive email as well. My Off site user are not able to connect to the exchange server only thru VPN. I installed SSL Cret [...]
Answer Question
| December 19, 2012 3:04 AM
Microsoft Exchange 2010, Microsoft Exchange errors
Invite attendees
In Outlook calendar can you invite an attendee for only a portion of a meeting time? Say the meeting is already scheduled for 2 hours from 9:00-11:00 and you now want to invite someone for the first hour, from 9:00-10:00. Can that be done? If so, how?
Answer Question
| December 19, 2012 8:26 PM
Microsoft Outlook, Microsoft Outlook Calendar
In Outlook calendar can you invite an attendee for only a portion of a meeting time? Say the meeting is already scheduled for 2 hours from 9:00-11:00 and you now want to invite someone for the first hour, from 9:00-10:00. Can that be done? If so, how?
Answer Question
| December 19, 2012 8:26 PM
Microsoft Outlook, Microsoft Outlook Calendar
Question on time series
The daily output of your company over a four week period is shown in the table below: wk 1: monday 187 tues 2203 wed 208 thurs 207 fri 217 wk 2: mon 207 tues 208 wed 210 thurs 206 fr 212 wk 3 mon 202 tues 210 wed 212 thurs 205 fri 214 wk 4 [...]
Answer Question
| December 18, 2012 5:57 PM
table, Table Functions
The daily output of your company over a four week period is shown in the table below: wk 1: monday 187 tues 2203 wed 208 thurs 207 fri 217 wk 2: mon 207 tues 208 wed 210 thurs 206 fr 212 wk 3 mon 202 tues 210 wed 212 thurs 205 fri 214 wk 4 [...]
Answer Question
| December 18, 2012 5:57 PM
table, Table Functions
Signal receivers
I have to travel with my family for the Bharatdarshan, can I get something to find them if they lost in the crowd? Signal receiver or the catcher or the tracker?
Answer Question
| December 18, 2012 5:18 PM
Signal receiver
I have to travel with my family for the Bharatdarshan, can I get something to find them if they lost in the crowd? Signal receiver or the catcher or the tracker?
Answer Question
| December 18, 2012 5:18 PM
Signal receiver
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
