SQL or T-SQL
This question related to this thread: http://itknowledgeexchange.techtarget.com/itanswers/difference-between-sql-and-t-sqlmicrosoft-sql-server-2000/ So if I want to study SQL server, should I first study SQL and then T-SQL or just dive right in to T-SQL.
Answer Question
| November 8, 2012 10:13 PM
SQL Server, T-SQL
This question related to this thread: http://itknowledgeexchange.techtarget.com/itanswers/difference-between-sql-and-t-sqlmicrosoft-sql-server-2000/ So if I want to study SQL server, should I first study SQL and then T-SQL or just dive right in to T-SQL.
Answer Question
| November 8, 2012 10:13 PM
SQL Server, T-SQL
What does President Obama’s victory mean for the IT industry?
After President Obama’s election victory last night, many experts are wondering what technology policy changes he’ll make during his second term. In a visit to Silicon Valley last year, Steve Westly, managing partner of The Westly Group, said Obama was ‘The most technology oriented president in history‘. What do you think his victory means for [...]
Answer Question
| November 30, 2012 9:54 PM
IT industry, Technology
After President Obama’s election victory last night, many experts are wondering what technology policy changes he’ll make during his second term. In a visit to Silicon Valley last year, Steve Westly, managing partner of The Westly Group, said Obama was ‘The most technology oriented president in history‘. What do you think his victory means for [...]
Answer Question
| November 30, 2012 9:54 PM
IT industry, Technology
2- partitions, 2-system names
Can we have two logical partitions with the same system name? What are the pros and cons of having a different system name(s) for each partition?
Answer Question
| November 7, 2012 9:49 PM
iSeries
Can we have two logical partitions with the same system name? What are the pros and cons of having a different system name(s) for each partition?
Answer Question
| November 7, 2012 9:49 PM
iSeries
How can I get rid of the PJL STATUS command from the top of my AS/400 Reports?
I have just installed an IBM4247-003 printer to our AS400 via LAN connection. Everytime a report is printed, the top of the first page has a PJL command. We currently are on V5R2. I created the device as a Type(3812) Lanattach(*IP) Port(9100) MFRTYPMDL(*IBM4247DUAL) SYSDRVPGM(*IBMPJLDRV). The message that prints is below: 12345X@PJL USTATUSOFF -12345X @PJL INFO [...]
Answer Question
| November 7, 2012 9:20 PM
configuration, Header, IBM4247, LAN
I have just installed an IBM4247-003 printer to our AS400 via LAN connection. Everytime a report is printed, the top of the first page has a PJL command. We currently are on V5R2. I created the device as a Type(3812) Lanattach(*IP) Port(9100) MFRTYPMDL(*IBM4247DUAL) SYSDRVPGM(*IBMPJLDRV). The message that prints is below: 12345X@PJL USTATUSOFF -12345X @PJL INFO [...]
Answer Question
| November 7, 2012 9:20 PM
configuration, Header, IBM4247, LAN
Why do I get a %OD at the end of my links in mt .pdf?
Why do I get a %OD at the end of my links in mt .pdf?
Answer Question
| November 7, 2012 7:51 PM
%OD
Why do I get a %OD at the end of my links in mt .pdf?
Answer Question
| November 7, 2012 7:51 PM
%OD
Create a Hotspot URL and pass it into an email
Trying to programatically create a Hotspot URL inside an email. The hotspot would point to a location on our networks where the PDF’s reside, rather than attaching all PDF’s in the email. PDF’s are created from our iSeries and stored on the network. When the process is completed, it would create the Hotspot URL (network) [...]
Answer Question
| November 8, 2012 7:06 PM
Hotspots, Lotus Notes 8.5
Trying to programatically create a Hotspot URL inside an email. The hotspot would point to a location on our networks where the PDF’s reside, rather than attaching all PDF’s in the email. PDF’s are created from our iSeries and stored on the network. When the process is completed, it would create the Hotspot URL (network) [...]
Answer Question
| November 8, 2012 7:06 PM
Hotspots, Lotus Notes 8.5
Concatonating year using date parameter with extract function
I have a date parameter :ASOFDATE being entered as such: 01/01/2008. I would like the following to print out in my columns: 2008-09. The code I am using to attempt getting this is as follows: to_char(extract(year FROM to_date(:ASOFDATE, ‘DD-MM-YYYY’))) || ‘-’ || substr(extract(year FROM to_date(:ASOFDATE , ‘DD-MM-YYYY’) + 365), 3,2) The information that prints in [...]
Answer Question
| November 7, 2012 6:46 PM
SQL Server Query
I have a date parameter :ASOFDATE being entered as such: 01/01/2008. I would like the following to print out in my columns: 2008-09. The code I am using to attempt getting this is as follows: to_char(extract(year FROM to_date(:ASOFDATE, ‘DD-MM-YYYY’))) || ‘-’ || substr(extract(year FROM to_date(:ASOFDATE , ‘DD-MM-YYYY’) + 365), 3,2) The information that prints in [...]
Answer Question
| November 7, 2012 6:46 PM
SQL Server Query
Cloning a Production Virtual Server for Testing
We would like to clone one of our production win2003 virtual servers for testing software before we install on the actual server. What do you suggest the procedures. I remember in one of your articles that you mentioned not to clone a production server. How can I clone my production for a test environment. Thanks.
Answer Question
| November 7, 2012 5:46 PM
Virtual Servers
We would like to clone one of our production win2003 virtual servers for testing software before we install on the actual server. What do you suggest the procedures. I remember in one of your articles that you mentioned not to clone a production server. How can I clone my production for a test environment. Thanks.
Answer Question
| November 7, 2012 5:46 PM
Virtual Servers
Mobile Antivirus
I want to build an antivirus for android…so I need virus signature database…while surfing through net I could find that Dr. Web deals with android viruses…i downloaded one of its virus database…but its VDB…my system is not recognizing the software with which I can open it…I also tried using FileCure and it says .VDB file [...]
Answer Question
| November 7, 2012 5:41 PM
.VDB files, Antivirus, Mobile
I want to build an antivirus for android…so I need virus signature database…while surfing through net I could find that Dr. Web deals with android viruses…i downloaded one of its virus database…but its VDB…my system is not recognizing the software with which I can open it…I also tried using FileCure and it says .VDB file [...]
Answer Question
| November 7, 2012 5:41 PM
.VDB files, Antivirus, Mobile
Alternative name of Physical file
How to rename an alternative name(long name) in a physical file using sql or any other method.(Alternative name if present can be found using DSPFD) . No source is available for this physical file and only object is available.
Answer Question
| November 7, 2012 5:11 PM
AS 400, DB2/400, Physical File
How to rename an alternative name(long name) in a physical file using sql or any other method.(Alternative name if present can be found using DSPFD) . No source is available for this physical file and only object is available.
Answer Question
| November 7, 2012 5:11 PM
AS 400, DB2/400, Physical File
Replace icons/bookmarks for moved databases
How can I send an action to an Exchange mail (Outlook) user that can open their Lotus Notes client and replace bookmarks and icons? I have a large enterprise that is migrating or has migrated to Exchange for mail. I am working on a project to consolidate Lotus Notes applications into Regional Operations Centers, and [...]
Answer Question
| November 7, 2012 4:56 PM
Lotus Notes 8.0.2, Microsoft Outlook
How can I send an action to an Exchange mail (Outlook) user that can open their Lotus Notes client and replace bookmarks and icons? I have a large enterprise that is migrating or has migrated to Exchange for mail. I am working on a project to consolidate Lotus Notes applications into Regional Operations Centers, and [...]
Answer Question
| November 7, 2012 4:56 PM
Lotus Notes 8.0.2, Microsoft Outlook
AS/400 FTP server won’t start
After a savsys restore due to a disk crash, the FTP server won’t start. Following is the joblog entry : Message . . . . : Exception CPF3CDB occurred when trying to get information for exit point QIBM_QTMF_SERVER_REQ with format name VLRQ0100. Cause . . . . . : The QusRetrieveExitInformation API returned an exception [...]
Answer Question
| November 7, 2012 3:52 PM
AS/400, AS/400 FTP
After a savsys restore due to a disk crash, the FTP server won’t start. Following is the joblog entry : Message . . . . : Exception CPF3CDB occurred when trying to get information for exit point QIBM_QTMF_SERVER_REQ with format name VLRQ0100. Cause . . . . . : The QusRetrieveExitInformation API returned an exception [...]
Answer Question
| November 7, 2012 3:52 PM
AS/400, AS/400 FTP
Formatting Cells individually in a Table – Microsoft Access
I am currently in the process of using a Table to track employee annual leave, I need to be able to highlight all the weekends (saturday and sundays) in a different color to make easier to read. How do I do this?
Answer Question
| November 7, 2012 12:17 PM
Microsoft Access 2010, Microsoft Access tables
I am currently in the process of using a Table to track employee annual leave, I need to be able to highlight all the weekends (saturday and sundays) in a different color to make easier to read. How do I do this?
Answer Question
| November 7, 2012 12:17 PM
Microsoft Access 2010, Microsoft Access tables
How to map HTML page with AS400
I have an HTML page with NAME field. When user enter the in the page and click on the submit it should go in the PF file and add the record in the PF. Is it possible that we can map the HTML pages with AS400. Please give some link or code where I can [...]
Answer Question
| November 7, 2012 12:11 PM
AS/400
I have an HTML page with NAME field. When user enter the in the page and click on the submit it should go in the PF file and add the record in the PF. Is it possible that we can map the HTML pages with AS400. Please give some link or code where I can [...]
Answer Question
| November 7, 2012 12:11 PM
AS/400
Windows Server 2003 email forward
I need to create an email address and then forward this address to an external address, any help would be appreciated.
Answer Question
| November 7, 2012 11:30 AM
Microsoft Exchange 2003, Windows Server 2003
I need to create an email address and then forward this address to an external address, any help would be appreciated.
Answer Question
| November 7, 2012 11:30 AM
Microsoft Exchange 2003, Windows Server 2003
Need information on content manager on iSeries
Hi, is there anyone working on content manager integrated with GUI applications on iSeries. I have the basic codes and admin pdfs from IBM but require some practical troubleshooting documentation on errors loading content manager.
Answer Question
| November 7, 2012 11:23 AM
AS/400, AS400 admin
Hi, is there anyone working on content manager integrated with GUI applications on iSeries. I have the basic codes and admin pdfs from IBM but require some practical troubleshooting documentation on errors loading content manager.
Answer Question
| November 7, 2012 11:23 AM
AS/400, AS400 admin
Corrupt full access permissions Exchange 2010
I have a user trying to access a shared mailbox but they were getting an error saying: ‘the set of folders cannot be opened. Microsoft Exchange is not available.Either there are networks problems or the Exchange server is down for maintenance’ Removing the full access permissions and re-adding them has resolved the issue. This is [...]
Answer Question
| November 7, 2012 10:32 AM
Microsoft Exchange 2010, Microsoft Exchange errors
I have a user trying to access a shared mailbox but they were getting an error saying: ‘the set of folders cannot be opened. Microsoft Exchange is not available.Either there are networks problems or the Exchange server is down for maintenance’ Removing the full access permissions and re-adding them has resolved the issue. This is [...]
Answer Question
| November 7, 2012 10:32 AM
Microsoft Exchange 2010, Microsoft Exchange errors
QSECURITY 40
Hi All, If I was on QSecurity 30 and shifted the operations to QSecurity 40, knowing that my collected audits collections (logs from QAUDLVL) are ok and passed all possible program failures. Now during operations problems occured. Boom! Can I immediately revert back to QSECURITY 30 and continue my operations? What will happen to my [...]
Answer Question
| November 7, 2012 9:28 AM
iSeries AS/400
Hi All, If I was on QSecurity 30 and shifted the operations to QSecurity 40, knowing that my collected audits collections (logs from QAUDLVL) are ok and passed all possible program failures. Now during operations problems occured. Boom! Can I immediately revert back to QSECURITY 30 and continue my operations? What will happen to my [...]
Answer Question
| November 7, 2012 9:28 AM
iSeries AS/400
How do you display user profile authority and object access
Hi all, I would like to know if there is a command to check the private authority of a user profile over all objects inside the iSeries. Thank you
Answer Question
| November 7, 2012 9:18 AM
iSeries, iSeries AS/400, iSeries 820
Hi all, I would like to know if there is a command to check the private authority of a user profile over all objects inside the iSeries. Thank you
Answer Question
| November 7, 2012 9:18 AM
iSeries, iSeries AS/400, iSeries 820
Internet connection problem
Since a couple of years I am experiencing a peculiar problem. I use 3g Data card(USB modem ) for my Internet connection. After some time a pop up is displayed in the desk top screen written as ” This USB device can perform faster if you connect it to to a high speed USB 2.0 [...]
Answer Question
| November 7, 2012 4:21 AM
Internet connection, USB Modem
Since a couple of years I am experiencing a peculiar problem. I use 3g Data card(USB modem ) for my Internet connection. After some time a pop up is displayed in the desk top screen written as ” This USB device can perform faster if you connect it to to a high speed USB 2.0 [...]
Answer Question
| November 7, 2012 4:21 AM
Internet connection, USB Modem
