how to retrieve current date and time in SQL400
i got the perfect answer… <b>SELECT CURDATE() FROM SYSIBM/SYSDUMMY1 SELECT CURDATE() FROM SYSIBM.SYSDUMMY1</b> In inteactive SQL – F13 last item on page is Naming convention *SYS/*SQL *SYS support ” / ” *SQL support (dot) ” . ” <b>SELECT CURTIME() FROM SYSIBM/SYSDUMMY1 SELECT NOW() FROM SYSIBM/SYSDUMMY1 </b> – for both date and time… thanks Mr. Phil [...]
View Answer
| January 24, 2012 5:59 AM
SQL/400
i got the perfect answer… <b>SELECT CURDATE() FROM SYSIBM/SYSDUMMY1 SELECT CURDATE() FROM SYSIBM.SYSDUMMY1</b> In inteactive SQL – F13 last item on page is Naming convention *SYS/*SQL *SYS support ” / ” *SQL support (dot) ” . ” <b>SELECT CURTIME() FROM SYSIBM/SYSDUMMY1 SELECT NOW() FROM SYSIBM/SYSDUMMY1 </b> – for both date and time… thanks Mr. Phil [...]
View Answer
| January 24, 2012 5:59 AM
SQL/400
Printing from adobe 10x
When trying to print an adobe pdf file from an e-mail, a box comes up and says “adobe reader stopped working.” Windows then closes the program and no printing occurs. Thinking my previous adobe reader was corrupt or something, I uninstalled it and download a “fresh” version of 10x. Same result.
View Answer
| January 23, 2012 8:57 PM
Adobe Acrobat, HP Pavilion, Microsoft Windows Vista
When trying to print an adobe pdf file from an e-mail, a box comes up and says “adobe reader stopped working.” Windows then closes the program and no printing occurs. Thinking my previous adobe reader was corrupt or something, I uninstalled it and download a “fresh” version of 10x. Same result.
View Answer
| January 23, 2012 8:57 PM
Adobe Acrobat, HP Pavilion, Microsoft Windows Vista
what is the next path after helpdesk
The help desk is a career path with many good options. You are obviously very interested in networking and this is a good career path with very good earnings potential and longevity. What you do next depends on inside versus outside opportunities. Start by keeping an eye on your current companies job posting in IT [...]
View Answer
| January 23, 2012 5:33 AM
Networking
The help desk is a career path with many good options. You are obviously very interested in networking and this is a good career path with very good earnings potential and longevity. What you do next depends on inside versus outside opportunities. Start by keeping an eye on your current companies job posting in IT [...]
View Answer
| January 23, 2012 5:33 AM
Networking
how to create autonumber
using a sequence for that
View Answer
| January 23, 2012 4:29 AM
AutoNumber, Excel 2007, Excel VBA, VBA, Visual Basic for Applications
using a sequence for that
View Answer
| January 23, 2012 4:29 AM
AutoNumber, Excel 2007, Excel VBA, VBA, Visual Basic for Applications
oracle
You can use Oracle’s Change Management Pack, TOAD for Oracle from Quest Software, or Oracle Schema Compare from Red Gate Software to compare the structure and contents of two tables. You can use the “describe” command in SQL*Plus also to show the structure of a table and determine differences.
View Answer
| January 22, 2012 12:52 PM
Oracle Schema, Oracle Table, Toad Data Modeler
You can use Oracle’s Change Management Pack, TOAD for Oracle from Quest Software, or Oracle Schema Compare from Red Gate Software to compare the structure and contents of two tables. You can use the “describe” command in SQL*Plus also to show the structure of a table and determine differences.
View Answer
| January 22, 2012 12:52 PM
Oracle Schema, Oracle Table, Toad Data Modeler
IT Scripts Entry
Restores the Windows Firewall with Advanced Security policy to the default policy. The current active policy can be optionally exported to a specified file. In a Group Policy object, this command returns all settings to not configured and deletes all connection security and firewall rules… <a href=”http://personalvpnreviews.com/”>VPN Reviews</a> thanks
View Answer
| January 22, 2012 11:34 AM
Batch Scripts, IT Scripts, ITKE Contests
Restores the Windows Firewall with Advanced Security policy to the default policy. The current active policy can be optionally exported to a specified file. In a Group Policy object, this command returns all settings to not configured and deletes all connection security and firewall rules… <a href=”http://personalvpnreviews.com/”>VPN Reviews</a> thanks
View Answer
| January 22, 2012 11:34 AM
Batch Scripts, IT Scripts, ITKE Contests
“Setup was unable to load the master information file’ when I Install optional windows components
i think, just you extracting Sysoc.inf file from Windows XP Insert the Windows XP CD in the drive. Click Start/Run and type CMD In the Command Prompt, type this line: expand X:i386sysoc.in_ -r c:windowsinf Where X: is your CD-ROM drive letter. The above command assumes Windows is installed in C: drive. If not, change the [...]
View Answer
| January 22, 2012 10:14 AM
IIS, Windows XP SP3
i think, just you extracting Sysoc.inf file from Windows XP Insert the Windows XP CD in the drive. Click Start/Run and type CMD In the Command Prompt, type this line: expand X:i386sysoc.in_ -r c:windowsinf Where X: is your CD-ROM drive letter. The above command assumes Windows is installed in C: drive. If not, change the [...]
View Answer
| January 22, 2012 10:14 AM
IIS, Windows XP SP3
Importing contact list
Log on to your Google Gmail account. In the upper left corner, left click Mail, then click Contacts. Above the Contacts list in the center of screen, click More, then click Export. Click Outlook CSV (for import into Outlook clients). Click Export Contacts. When prompted to download the export file, click Save. Choose a location [...]
View Answer
| January 21, 2012 6:54 PM
contact lists
Log on to your Google Gmail account. In the upper left corner, left click Mail, then click Contacts. Above the Contacts list in the center of screen, click More, then click Export. Click Outlook CSV (for import into Outlook clients). Click Export Contacts. When prompted to download the export file, click Save. Choose a location [...]
View Answer
| January 21, 2012 6:54 PM
contact lists
USB Smartbro MF190
You can check this post to fix on this kind of error in <a href=”http://cebuanddavao.com/2011/11/10/how-installers-set-up-smart-bro-canopy-wireless-broadband-internet/”>smart Bro canopy</a> and smart bro plug-it:http://cebuanddavao.com/2011/11/10/how-installers-set-up-smart-bro-canopy-wireless-broadband-internet/
View Answer
| January 21, 2012 4:41 AM
Remote connection, USB Smartbro MF190
You can check this post to fix on this kind of error in <a href=”http://cebuanddavao.com/2011/11/10/how-installers-set-up-smart-bro-canopy-wireless-broadband-internet/”>smart Bro canopy</a> and smart bro plug-it:http://cebuanddavao.com/2011/11/10/how-installers-set-up-smart-bro-canopy-wireless-broadband-internet/
View Answer
| January 21, 2012 4:41 AM
Remote connection, USB Smartbro MF190
AS/400 Client Access.
Also, check the LOCALE setting. The LOCALE may work for 60 days, then needs to be reset.
View Answer
| January 21, 2012 1:34 AM
AS/400 Client Access
Also, check the LOCALE setting. The LOCALE may work for 60 days, then needs to be reset.
View Answer
| January 21, 2012 1:34 AM
AS/400 Client Access
Prod and Test environment
A PROD enviornment is all objects that are in your PRODUCTION enviornment. This for not to be used for testing. A TEST enviornment is alll the necessary objects required for testing programming changes. This way when you are testing changes that update files, you are not effecting your production files. Your TEST enviornment does not [...]
View Answer
| January 20, 2012 5:53 PM
AS/400, AS/400 testing
A PROD enviornment is all objects that are in your PRODUCTION enviornment. This for not to be used for testing. A TEST enviornment is alll the necessary objects required for testing programming changes. This way when you are testing changes that update files, you are not effecting your production files. Your TEST enviornment does not [...]
View Answer
| January 20, 2012 5:53 PM
AS/400, AS/400 testing
How to use auto fill in Microsoft Word
it possible in Microsoft Word 2007….. just follow my steps….. 1) Click where you want to insert the date or time. 2) On the Insert menu, click Date and Time. it will show you multiple format of date and time. just you choose any format… 3) select option “update automatically” in check box… To insert [...]
View Answer
| January 20, 2012 5:37 PM
Microsoft Office 2007, Microsoft Word 2007
it possible in Microsoft Word 2007….. just follow my steps….. 1) Click where you want to insert the date or time. 2) On the Insert menu, click Date and Time. it will show you multiple format of date and time. just you choose any format… 3) select option “update automatically” in check box… To insert [...]
View Answer
| January 20, 2012 5:37 PM
Microsoft Office 2007, Microsoft Word 2007
Retrieving package for V6R1
I have found the best way to obtain a CUM, especially if you are more than 1 level behind, is to go ahead and order them on media from Fix Central. There are a few extra steps involved to load it from DVD, but, when you take into account the time spent trying to download [...]
View Answer
| January 20, 2012 3:00 PM
CUM PTFs, Cumulative PTF Package, iSeries V6R1
I have found the best way to obtain a CUM, especially if you are more than 1 level behind, is to go ahead and order them on media from Fix Central. There are a few extra steps involved to load it from DVD, but, when you take into account the time spent trying to download [...]
View Answer
| January 20, 2012 3:00 PM
CUM PTFs, Cumulative PTF Package, iSeries V6R1
How to make my VB.Net application communicate with a barcode scanner
The scanner should come with some documentation, which should help you get started. For most scanners you just need to set focus to a text field, and the scanned text will be automatically copied into that text field without any intervention from the application.
View Answer
| January 20, 2012 2:09 PM
VB.NET, VB.NET 2008
The scanner should come with some documentation, which should help you get started. For most scanners you just need to set focus to a text field, and the scanned text will be automatically copied into that text field without any intervention from the application.
View Answer
| January 20, 2012 2:09 PM
VB.NET, VB.NET 2008
Special Files In RPG
The way this works is that you supply the name of the “I/O handler” program that handles the file operations in a keyword on the F spec (PGMNAME). A standard parameter list is sent to that program whenever any I/O operation is performed on the file. The standard parameter list includes the action or operation [...]
View Answer
| January 20, 2012 9:14 AM
AS400. RPG, AS400/RPG
The way this works is that you supply the name of the “I/O handler” program that handles the file operations in a keyword on the F spec (PGMNAME). A standard parameter list is sent to that program whenever any I/O operation is performed on the file. The standard parameter list includes the action or operation [...]
View Answer
| January 20, 2012 9:14 AM
AS400. RPG, AS400/RPG
Failed ODBC USER DSN connection to SQL Server 2005
<a href=”http://computerallofsolution.blogspot.com/”>
View Answer
| January 20, 2012 4:11 AM
SQL Server 2005, VB.NET
<a href=”http://computerallofsolution.blogspot.com/”>
View Answer
| January 20, 2012 4:11 AM
SQL Server 2005, VB.NET
sc password reset on SUN V245
Just connect to the Alom in serial port and power down the server and remove the power cards wait a couple of seconds. Again unplug the power card Alom booting that time you press EScap Key on ALOM menu you press E for erase the Alom NVRAM variables and press R to return now you [...]
View Answer
| January 20, 2012 12:20 AM
Oracle
Just connect to the Alom in serial port and power down the server and remove the power cards wait a couple of seconds. Again unplug the power card Alom booting that time you press EScap Key on ALOM menu you press E for erase the Alom NVRAM variables and press R to return now you [...]
View Answer
| January 20, 2012 12:20 AM
Oracle
Batch scripting question: Progress Indicator
You can try this code (found on www.dostips.com) which uses the DOS window title as a progress indicator - @ECHO OFF set “max=11″ call :initProgress %max% “Window Title: [PPP]” for /l %%N in (1,1,%max%) do ( ping -n 2 -w 1 127.0.0.1>NUL call:doProgress ) GOTO:EOF :initProgress max format — initialize an internal progress counter and [...]
View Answer
| January 20, 2012 12:07 AM
Batch, DOS, Scripting
You can try this code (found on www.dostips.com) which uses the DOS window title as a progress indicator - @ECHO OFF set “max=11″ call :initProgress %max% “Window Title: [PPP]” for /l %%N in (1,1,%max%) do ( ping -n 2 -w 1 127.0.0.1>NUL call:doProgress ) GOTO:EOF :initProgress max format — initialize an internal progress counter and [...]
View Answer
| January 20, 2012 12:07 AM
Batch, DOS, Scripting
Why can’t I connect to SQL Server 2005 through ODBC ?
Your connection string should look something like this. <pre>Provider=SQLNCLI;Server=backend;Database=zkp_database;Uid=myUsername; Pwd=myPassword;</pre> Don’t bother with the SQL Alias. When you use this connection string what is the error message that you are getting?
View Answer
| January 19, 2012 10:59 PM
ASP, ODBC Microsoft Access Driver Login Failed, SQL Server 2005 connectivity
Your connection string should look something like this. <pre>Provider=SQLNCLI;Server=backend;Database=zkp_database;Uid=myUsername; Pwd=myPassword;</pre> Don’t bother with the SQL Alias. When you use this connection string what is the error message that you are getting?
View Answer
| January 19, 2012 10:59 PM
ASP, ODBC Microsoft Access Driver Login Failed, SQL Server 2005 connectivity
Reoccurring WebEx Meetings
Yes, and here are the instructions on how to do so: For Meeting Center Sessions from your WebEx Site: Click on Schedule a Meeting from the left-hand navigation after logging into your company’s branded WebEx site. Click on the Advanced Scheduler directly under the words Schedule a Meeting. Click on the Date & Time item [...]
View Answer
| January 19, 2012 6:05 PM
WebEx
Yes, and here are the instructions on how to do so: For Meeting Center Sessions from your WebEx Site: Click on Schedule a Meeting from the left-hand navigation after logging into your company’s branded WebEx site. Click on the Advanced Scheduler directly under the words Schedule a Meeting. Click on the Date & Time item [...]
View Answer
| January 19, 2012 6:05 PM
WebEx
