SQL Command
Thanks friend, SQL on AS/400 and no in SQL Server. Hello Silvarb, if you are using MS SQL 2005 <a href=”http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1127863,00.html”>you can read this</a>, otherwise please be more specific and post more information on the SQL you are using. Bye ============================================================= If the user interface to SQL is through QM, then yes, you can prohibit [...]
View Answer
| April 22, 2010 3:51 AM
AS/400, SQL
Thanks friend, SQL on AS/400 and no in SQL Server. Hello Silvarb, if you are using MS SQL 2005 <a href=”http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1127863,00.html”>you can read this</a>, otherwise please be more specific and post more information on the SQL you are using. Bye ============================================================= If the user interface to SQL is through QM, then yes, you can prohibit [...]
View Answer
| April 22, 2010 3:51 AM
AS/400, SQL
DOT NET SQL CONNECTION TIME OUT PROBLEM
The timeout in the connection string is the connection timeout, not the command runtime timeout. Within your .NET code on the object which executes the stored procedure you should be able to set a timeout parameter. This will change the runtime timeout for that command.
View Answer
| April 21, 2010 4:41 PM
.NET, SQL connection, SQL Connection Timeout
The timeout in the connection string is the connection timeout, not the command runtime timeout. Within your .NET code on the object which executes the stored procedure you should be able to set a timeout parameter. This will change the runtime timeout for that command.
View Answer
| April 21, 2010 4:41 PM
.NET, SQL connection, SQL Connection Timeout
RPG/400 How to Pass Hexa values
Hi, Just pass it as a character string – should work. Regards, Martin Gilbert. ============================================================= Every parameter value is always a hexadecimal value; they just aren’t often specified in hexadecimal notation. Therefore, the question doesn’t quite make sense. If nothing else, at least an indication of what language is being asked about would be helpful. [...]
View Answer
| April 21, 2010 8:32 AM
AS/400, Hexadecimal values, RPG, RPG/400
Hi, Just pass it as a character string – should work. Regards, Martin Gilbert. ============================================================= Every parameter value is always a hexadecimal value; they just aren’t often specified in hexadecimal notation. Therefore, the question doesn’t quite make sense. If nothing else, at least an indication of what language is being asked about would be helpful. [...]
View Answer
| April 21, 2010 8:32 AM
AS/400, Hexadecimal values, RPG, RPG/400
RPG-XML
Yes – flat file. I think there are some generation tools but you can also write these using RPG Just remember every tag must match an end tag and nesting must be correct. <Tag> </Tag> No exceptions .. If I remember correctly you can test in word or explorer. Phil ///////////////////////////////// Hi Devan, Initially you [...]
View Answer
| April 20, 2010 11:55 PM
RPGILE, XML
Yes – flat file. I think there are some generation tools but you can also write these using RPG Just remember every tag must match an end tag and nesting must be correct. <Tag> </Tag> No exceptions .. If I remember correctly you can test in word or explorer. Phil ///////////////////////////////// Hi Devan, Initially you [...]
View Answer
| April 20, 2010 11:55 PM
RPGILE, XML
SNDUSRMSG equivalent in RPG (including VALUES and DFT)
http://archive.midrange.com/rpg400-l/200405/msg00228.html Here is another discussion on that topic. K ============================================================ Since the QMHSNDM API has no parameters to specify VALUES or DFT, you can’t pass them in when you call the API. If you must use them, then simply use the SNDUSRMSG command. That’s why it exists — for you to run it in a [...]
View Answer
| April 20, 2010 10:59 PM
API, AS/400, CL, iSeries, RPG, SNDUSRMSG
http://archive.midrange.com/rpg400-l/200405/msg00228.html Here is another discussion on that topic. K ============================================================ Since the QMHSNDM API has no parameters to specify VALUES or DFT, you can’t pass them in when you call the API. If you must use them, then simply use the SNDUSRMSG command. That’s why it exists — for you to run it in a [...]
View Answer
| April 20, 2010 10:59 PM
API, AS/400, CL, iSeries, RPG, SNDUSRMSG
How can I get the name of a “String” variable/object returned to a usable string in my program ?
Inside your function, there is no way to know that arg1 is receiving the value from a variable called ‘myName’. Outside your function, you could probably use the reflection api if we were talking about class fields. As for variable names, depending on how you compile your program, some debug information (including local variable names) [...]
View Answer
| April 20, 2010 9:35 PM
Java, Java development, java script, String name
Inside your function, there is no way to know that arg1 is receiving the value from a variable called ‘myName’. Outside your function, you could probably use the reflection api if we were talking about class fields. As for variable names, depending on how you compile your program, some debug information (including local variable names) [...]
View Answer
| April 20, 2010 9:35 PM
Java, Java development, java script, String name
How useful is SCJP?
You need to go with your interest. It is not guaranteed that if you have done some certification you will get good job Certification will definitely help to get a job, but first make a success of you current studies, and then while you are looking for a job start pursuing SCJP. If you can [...]
View Answer
| April 20, 2010 10:42 AM
IT careers, SCJP, Sun Certifications
You need to go with your interest. It is not guaranteed that if you have done some certification you will get good job Certification will definitely help to get a job, but first make a success of you current studies, and then while you are looking for a job start pursuing SCJP. If you can [...]
View Answer
| April 20, 2010 10:42 AM
IT careers, SCJP, Sun Certifications
Which certification will benefit me
Hi Amrathi. If I were in your situation I would have gone for the “SAP Certified Application Associate – Project Management with SAP ERP 6.0″ certification, get a job that have some project management as part of the job description and only after that pursue the PMP qualification. I dont know your situation, but if [...]
View Answer
| April 20, 2010 9:53 AM
IT careers, PMP, Project management, SAP certifications, SAP Enterprise Resource Planning, SAP SRM, Supplier relationship management
Hi Amrathi. If I were in your situation I would have gone for the “SAP Certified Application Associate – Project Management with SAP ERP 6.0″ certification, get a job that have some project management as part of the job description and only after that pursue the PMP qualification. I dont know your situation, but if [...]
View Answer
| April 20, 2010 9:53 AM
IT careers, PMP, Project management, SAP certifications, SAP Enterprise Resource Planning, SAP SRM, Supplier relationship management
Error when executing RUNSQLSTM from CL program
You cannot run a SELECT using RUNSQLSTM. ============================================== SELECT is not allowed in RUNSQLSTM simply because it’s meaningless. Once selected, there is no facility in RUNSQLSTM actually to do anything with the selected rows and columns. If a SELECT is intended, then it must be embedded in some program that can perform the necessary I/O [...]
View Answer
| April 20, 2010 7:32 AM
AS/400, AS/400 errors, CL, RUNSQLSTM, SQL
You cannot run a SELECT using RUNSQLSTM. ============================================== SELECT is not allowed in RUNSQLSTM simply because it’s meaningless. Once selected, there is no facility in RUNSQLSTM actually to do anything with the selected rows and columns. If a SELECT is intended, then it must be embedded in some program that can perform the necessary I/O [...]
View Answer
| April 20, 2010 7:32 AM
AS/400, AS/400 errors, CL, RUNSQLSTM, SQL
Save or export vb 6 form
Basically you have to: -Include a picture box control in your form -Resize it to the size of your form -Use the BitBlt function to copy the form image to the pincture box -Save the contents of the picture box to disk. <a href=”http://www.codeproject.com/KB/vb-interop/SaveFormImageToFile.aspx”>Here</a> is some example code.
View Answer
| April 19, 2010 5:09 PM
Access Database, Database import/export, PDF, save or export vb 6 form, VB 6
Basically you have to: -Include a picture box control in your form -Resize it to the size of your form -Use the BitBlt function to copy the form image to the pincture box -Save the contents of the picture box to disk. <a href=”http://www.codeproject.com/KB/vb-interop/SaveFormImageToFile.aspx”>Here</a> is some example code.
View Answer
| April 19, 2010 5:09 PM
Access Database, Database import/export, PDF, save or export vb 6 form, VB 6
Need a sample code for Sql fetching multiple rows
I’ve noticed this has been unanswered for a while. I have some expertise in RPG, not COBOL (sorry), but maybe this will help since RPG and COBOL on the iSeries are similar. I’m assuming the embedded SQL is the same. In the sample code below I move SQL results into RPG (program) variables. Those program [...]
View Answer
| April 17, 2010 12:35 AM
SQL, SQLCBLLE
I’ve noticed this has been unanswered for a while. I have some expertise in RPG, not COBOL (sorry), but maybe this will help since RPG and COBOL on the iSeries are similar. I’m assuming the embedded SQL is the same. In the sample code below I move SQL results into RPG (program) variables. Those program [...]
View Answer
| April 17, 2010 12:35 AM
SQL, SQLCBLLE
Have you taken a shot at the Intel Open Port IT Scavenger Hunt?
i want to know java interview Question & Answer
View Answer
| April 16, 2010 1:12 PM
AS/400, Channel, CIO, Contests, CRM, Data management, Database, DataCenter, Development, Exchange, Giveaways, Intel Open Port, ITKE, ITKE Contests, Knowledge Points, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SQL Server, Storage, Virtualization, VoIP
i want to know java interview Question & Answer
View Answer
| April 16, 2010 1:12 PM
AS/400, Channel, CIO, Contests, CRM, Data management, Database, DataCenter, Development, Exchange, Giveaways, Intel Open Port, ITKE, ITKE Contests, Knowledge Points, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SQL Server, Storage, Virtualization, VoIP
multiple forms
If you Google “vb mdi sdi” you will find many resources with examples of how to work with multiple forms. I am guessing your default forms interface in your development environment is SDI (or Single Document Interface). In this mode, the application opens one main form window, and all other form windows open within the [...]
View Answer
| April 15, 2010 6:31 PM
VB 2008
If you Google “vb mdi sdi” you will find many resources with examples of how to work with multiple forms. I am guessing your default forms interface in your development environment is SDI (or Single Document Interface). In this mode, the application opens one main form window, and all other form windows open within the [...]
View Answer
| April 15, 2010 6:31 PM
VB 2008
create a batch file to have a permission to install software
If you are referring to “power users” in windows then you should consider using Group Policy to deploy permission to install software and even windows updates. By giving your users the rights you are considering, it would be impossible to control what software is installed and will create other administrative headaches. depending on your version [...]
View Answer
| April 14, 2010 11:07 PM
Remote management, Software, Software deployment, Software Deployment Tools
If you are referring to “power users” in windows then you should consider using Group Policy to deploy permission to install software and even windows updates. By giving your users the rights you are considering, it would be impossible to control what software is installed and will create other administrative headaches. depending on your version [...]
View Answer
| April 14, 2010 11:07 PM
Remote management, Software, Software deployment, Software Deployment Tools
Bandwidth management software recommendation
You may be able to utilize an open source router like DDR-WRT and the such. You can also look at Dan’s Guardian which may have the capability as per bandwidth management but it has the content filtering you are looking for.
View Answer
| April 13, 2010 4:45 PM
bandwidth allocation, Bandwidth management, Software requirements, Software to restrict Users
You may be able to utilize an open source router like DDR-WRT and the such. You can also look at Dan’s Guardian which may have the capability as per bandwidth management but it has the content filtering you are looking for.
View Answer
| April 13, 2010 4:45 PM
bandwidth allocation, Bandwidth management, Software requirements, Software to restrict Users
mysqldatetime exception
Hi, Me also got the same exception in my application, this is only happen by the Web.config file in out application, In web.config connection string we placed a property like : allow zero datetime=true; Please try to remove this in your connection string in web.config file.. thanks S.V.Narayana
View Answer
| April 13, 2010 7:43 AM
C#, MySQL
Hi, Me also got the same exception in my application, this is only happen by the Web.config file in out application, In web.config connection string we placed a property like : allow zero datetime=true; Please try to remove this in your connection string in web.config file.. thanks S.V.Narayana
View Answer
| April 13, 2010 7:43 AM
C#, MySQL
how to change AS/400 Textbase application to windowslike application
If you are just talking about the UI, you can use CGIDEV2 (free) to present your programs in a browser. You can also get commercial products that will convert your current green screen applications to web pages or let you create your own. Two that I have worked with are Websmart and RPGsp. That way [...]
View Answer
| April 12, 2010 7:09 PM
Applications development, AS/400, DDS, RPG
If you are just talking about the UI, you can use CGIDEV2 (free) to present your programs in a browser. You can also get commercial products that will convert your current green screen applications to web pages or let you create your own. Two that I have worked with are Websmart and RPGsp. That way [...]
View Answer
| April 12, 2010 7:09 PM
Applications development, AS/400, DDS, RPG
Screen scrapping
There are no readymade tools I’m aware of for screen scarping in VB but ASP.net is the way to go and there are good resources on how to code this, see <a href=”http://aspalliance.com/236_NET_Screen_Scraping_in_depth.all”>http://aspalliance.com/236_NET_Screen_Scraping_in_depth.all</a> <a href=”http://devcity.net/Articles/48/1/screen_scrape.aspx”>http://devcity.net/Articles/48/1/screen_scrape.aspx</a> and here is a software written in ASP <a href=”http://www.offenderaware.com/asp-screen-scrape”>http://www.offenderaware.com/asp-screen-scrape</a>
View Answer
| April 11, 2010 12:27 AM
ASP.NET 3.5, VB.NET 2008
There are no readymade tools I’m aware of for screen scarping in VB but ASP.net is the way to go and there are good resources on how to code this, see <a href=”http://aspalliance.com/236_NET_Screen_Scraping_in_depth.all”>http://aspalliance.com/236_NET_Screen_Scraping_in_depth.all</a> <a href=”http://devcity.net/Articles/48/1/screen_scrape.aspx”>http://devcity.net/Articles/48/1/screen_scrape.aspx</a> and here is a software written in ASP <a href=”http://www.offenderaware.com/asp-screen-scrape”>http://www.offenderaware.com/asp-screen-scrape</a>
View Answer
| April 11, 2010 12:27 AM
ASP.NET 3.5, VB.NET 2008
move emails from pop server to inbox of outlook express and keep 1 cc in inbox of pop server?
Go into the properties of your outlook express account. Go to the server settings in advanced and check the box for “leave a copy of the emails on the server”
View Answer
| April 9, 2010 7:40 PM
Microsoft Office, Outlook Express 2007, POP server, Windows Vista, Yahoo
Go into the properties of your outlook express account. Go to the server settings in advanced and check the box for “leave a copy of the emails on the server”
View Answer
| April 9, 2010 7:40 PM
Microsoft Office, Outlook Express 2007, POP server, Windows Vista, Yahoo
How can I prevent unauthorized copying of a PDF file from a CD/DVD
Not sure if it’s possible but try adjusting the file properties by right clicking and deny all options except read. That <i>MIGHT</i> work.. If someone want the contents bad enough they will find a way around it like they do copyrighted movies, and the movie industry has a lot more to lose.
View Answer
| April 9, 2010 7:28 PM
Acrobat 9, Adobe Acrobat, Copy To PC Document, PDF
Not sure if it’s possible but try adjusting the file properties by right clicking and deny all options except read. That <i>MIGHT</i> work.. If someone want the contents bad enough they will find a way around it like they do copyrighted movies, and the movie industry has a lot more to lose.
View Answer
| April 9, 2010 7:28 PM
Acrobat 9, Adobe Acrobat, Copy To PC Document, PDF
