Exporting a (.csv) file from SQL 2005
welcome to: http://www.plzzshop.com The website wholesale for many kinds of fashion shoes, like the nike,jordan,prada,****, also including the jeans,shirts,bags,hat and the decorations. All the products are free shipping, and the the price is competitive, and also can accept the paypal payment.,after the payment, can ship within short time. free shipping competitive price any size available [...]
View Answer
| January 14, 2012 2:57 AM
CSV, SQL
welcome to: http://www.plzzshop.com The website wholesale for many kinds of fashion shoes, like the nike,jordan,prada,****, also including the jeans,shirts,bags,hat and the decorations. All the products are free shipping, and the the price is competitive, and also can accept the paypal payment.,after the payment, can ship within short time. free shipping competitive price any size available [...]
View Answer
| January 14, 2012 2:57 AM
CSV, SQL
Vb Script to get the selected(focussed) file names in a windows folder.
http://www.go4expert.com/forums/showthread.php?t=927 gives an example on reading a directory. I added the array part of it and commented out the write part of it. I write in vb but I’m not an expert in it so no promises. I prefer perl. I’m sure somebody else will chime in with another example. Here’s the code I ended [...]
View Answer
| January 13, 2012 9:16 PM
VB script
http://www.go4expert.com/forums/showthread.php?t=927 gives an example on reading a directory. I added the array part of it and commented out the write part of it. I write in vb but I’m not an expert in it so no promises. I prefer perl. I’m sure somebody else will chime in with another example. Here’s the code I ended [...]
View Answer
| January 13, 2012 9:16 PM
VB script
Creating DB of stories from documents for a website
I would recommend the Open Source Drupal content management (www.drupal.org) platform to create a searchable fanfiction database/website as all content is stored and searchable in the database which can be MySQL, Oracle, or SQL Server.
View Answer
| January 13, 2012 7:16 AM
Access Database, Access Database Design, Database design, Database Development, Database issues, Web development, Web development tools
I would recommend the Open Source Drupal content management (www.drupal.org) platform to create a searchable fanfiction database/website as all content is stored and searchable in the database which can be MySQL, Oracle, or SQL Server.
View Answer
| January 13, 2012 7:16 AM
Access Database, Access Database Design, Database design, Database Development, Database issues, Web development, Web development tools
iSeries : Current Un Protected Usage.
It’s been a while since I had to look into a problem like this but… Does the value change during the day? or from day to day? If the large difference is showing it may be due to a system IPL. If it’s changing during the day it may be due to the number of [...]
View Answer
| January 12, 2012 4:12 PM
ASP, DASD, Memory, RAM
It’s been a while since I had to look into a problem like this but… Does the value change during the day? or from day to day? If the large difference is showing it may be due to a system IPL. If it’s changing during the day it may be due to the number of [...]
View Answer
| January 12, 2012 4:12 PM
ASP, DASD, Memory, RAM
Execute SQL SELECT via RUNSQLSTM error
If you are just selecting records from a file, you cannot use SELECT if you are using RUNSQLSTM. If you are doing a different function such as INSERT or DELETE and basing this off of a selection from a different file, then you can use SELECT. I put a simple statement in a soiurce member [...]
View Answer
| January 11, 2012 5:11 PM
RUNSQLSTM, SELECT statement, SQL
If you are just selecting records from a file, you cannot use SELECT if you are using RUNSQLSTM. If you are doing a different function such as INSERT or DELETE and basing this off of a selection from a different file, then you can use SELECT. I put a simple statement in a soiurce member [...]
View Answer
| January 11, 2012 5:11 PM
RUNSQLSTM, SELECT statement, SQL
File system synchronization remotely
I would recommend using DropBox as it will automatically keep the local and remote contents in sync and is very reliable.
View Answer
| January 10, 2012 1:54 AM
File Synchronization, File System, J2EE, Java, Java/J2EE
I would recommend using DropBox as it will automatically keep the local and remote contents in sync and is very reliable.
View Answer
| January 10, 2012 1:54 AM
File Synchronization, File System, J2EE, Java, Java/J2EE
Test environment
I work at a major public academic health sciences center and have faced a similar challenge. We set up separate environments for development, test, quality assurance, production, and in some cases, reporting. It may seem like a lot of environments, but each one serves a critical purpose. Development is used to develop new applications and [...]
View Answer
| January 9, 2012 6:15 PM
Acceptance testing, Test Engineer
I work at a major public academic health sciences center and have faced a similar challenge. We set up separate environments for development, test, quality assurance, production, and in some cases, reporting. It may seem like a lot of environments, but each one serves a critical purpose. Development is used to develop new applications and [...]
View Answer
| January 9, 2012 6:15 PM
Acceptance testing, Test Engineer
Message when file does not exist
If you are doing the FTP from the iSeries, you can use source members to store the input and output of the FTP. OVRDBF FILE(INPUT) TOFILE(QTEMP/FTPCMD) OVRDBF FILE(OUTPUT) TOFILE(QTEMP/FTPLOG) FTP RMTSYS(&HOST) FTPCMD and FTPLOG were created with CRTSRCPF QTEMP/FTPxxx Once you do the FTP command, you can now go in and read the FTPLOG file [...]
View Answer
| January 9, 2012 3:25 PM
Error handling
If you are doing the FTP from the iSeries, you can use source members to store the input and output of the FTP. OVRDBF FILE(INPUT) TOFILE(QTEMP/FTPCMD) OVRDBF FILE(OUTPUT) TOFILE(QTEMP/FTPLOG) FTP RMTSYS(&HOST) FTPCMD and FTPLOG were created with CRTSRCPF QTEMP/FTPxxx Once you do the FTP command, you can now go in and read the FTPLOG file [...]
View Answer
| January 9, 2012 3:25 PM
Error handling
Even/Odd Numbers
Here is a link, from Ari Kaplan noted Oracle Magazine columnist and author of multiple Oracle books, which may be helpful assuming your question pertains to Oracle – http://www.arikaplan.com/oracle/ari33099.html
View Answer
| January 5, 2012 4:09 AM
Query
Here is a link, from Ari Kaplan noted Oracle Magazine columnist and author of multiple Oracle books, which may be helpful assuming your question pertains to Oracle – http://www.arikaplan.com/oracle/ari33099.html
View Answer
| January 5, 2012 4:09 AM
Query
Can you “read” a fax or email/attachment with a program or 3rd party tool?
I believe the GOAnywhere product from Linoma Software can do this. Here is a link to their website http://www.linomasoftware.com/products
View Answer
| January 4, 2012 9:39 PM
AS/400, Automation, Email, Fax
I believe the GOAnywhere product from Linoma Software can do this. Here is a link to their website http://www.linomasoftware.com/products
View Answer
| January 4, 2012 9:39 PM
AS/400, Automation, Email, Fax
SQL How to split out the Time from a DateTime col then use that in a WHERE Clause
The reason I needed the time splitting out was because I was working on an assignment to create a room booking project in vb.net. The database is stored in SQL Server and I had to use a table called Bookings which had the following 3 columns: BookDate StartTime EndTime I wanted to create a query [...]
View Answer
| January 4, 2012 3:43 PM
SQL, SQL Server
The reason I needed the time splitting out was because I was working on an assignment to create a room booking project in vb.net. The database is stored in SQL Server and I had to use a table called Bookings which had the following 3 columns: BookDate StartTime EndTime I wanted to create a query [...]
View Answer
| January 4, 2012 3:43 PM
SQL, SQL Server
about vb 6.0
Supposing your first form is named ‘Form1′ and it has a text box named ‘Text1′ which you want to access from other forms, you would write something like this in your other forms: <pre>SomeTextBox.Text = <b>Form1.</b>Text1.Text</pre>
View Answer
| January 3, 2012 2:38 PM
Coding, Form, Input, use
Supposing your first form is named ‘Form1′ and it has a text box named ‘Text1′ which you want to access from other forms, you would write something like this in your other forms: <pre>SomeTextBox.Text = <b>Form1.</b>Text1.Text</pre>
View Answer
| January 3, 2012 2:38 PM
Coding, Form, Input, use
Test Environment
Functionality and user acceptance testing can be performed in whatever environment you choose as long as the environment is used exclusively for one purpose at a time. We generally use four environments (development, test, user acceptance, and production). Development and test are used by the application developers to develop and test the application, while the [...]
View Answer
| January 2, 2012 11:54 PM
functionality testing, software testing environment, Staging Server, User acceptance testing
Functionality and user acceptance testing can be performed in whatever environment you choose as long as the environment is used exclusively for one purpose at a time. We generally use four environments (development, test, user acceptance, and production). Development and test are used by the application developers to develop and test the application, while the [...]
View Answer
| January 2, 2012 11:54 PM
functionality testing, software testing environment, Staging Server, User acceptance testing
Open IT Forum: What cloud concern do you need addressed?
OK I see two issues: 1. Larger organisations being able to allow internally-hosted and supported applications and webs. This does require in-house expertise or else contracted support and development from external organisations. However it may be preferable to host the data in-house (even if at a data centre) and retain maximum control. This needs to [...]
View Answer
| December 30, 2011 6:16 AM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
OK I see two issues: 1. Larger organisations being able to allow internally-hosted and supported applications and webs. This does require in-house expertise or else contracted support and development from external organisations. However it may be preferable to host the data in-house (even if at a data centre) and retain maximum control. This needs to [...]
View Answer
| December 30, 2011 6:16 AM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
What are your favorite cloud security blogs?
It’s not really a “blog” but it’all the rest ! Very good site with an system and application online vulnerabilities checking tool ! <a href=”http://secunia.com/vulnerability_scanning/online/?task=intro”></a> => http://secunia.com/vulnerability_scanning/online/?task=intro The best: https://blog.cloudsecurityalliance.org/
View Answer
| December 30, 2011 6:14 AM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, Security bloggers, SQL Server, Storage, Virtualization, VoIP, Windows Server
It’s not really a “blog” but it’all the rest ! Very good site with an system and application online vulnerabilities checking tool ! <a href=”http://secunia.com/vulnerability_scanning/online/?task=intro”></a> => http://secunia.com/vulnerability_scanning/online/?task=intro The best: https://blog.cloudsecurityalliance.org/
View Answer
| December 30, 2011 6:14 AM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, Security bloggers, SQL Server, Storage, Virtualization, VoIP, Windows Server
Amazon EC2 environment for my data/cloud security
You can Encrypt the data and store on Amazon S3; AWS provides encryption
View Answer
| December 30, 2011 6:11 AM
Amazon, Amazon EC2, Cloud Computing, Cloud Security, Cloud Services, Development Environments
You can Encrypt the data and store on Amazon S3; AWS provides encryption
View Answer
| December 30, 2011 6:11 AM
Amazon, Amazon EC2, Cloud Computing, Cloud Security, Cloud Services, Development Environments
Suggestions for cloud governance tools for an SMB’s hybrid cloud?
enStratus is the one you may be looking for.
View Answer
| December 30, 2011 6:10 AM
Cloud Computing, Cloud Security, Cloud Services, Hybrid clouds, Performance Measurement, Performance metrics, SMB
enStratus is the one you may be looking for.
View Answer
| December 30, 2011 6:10 AM
Cloud Computing, Cloud Security, Cloud Services, Hybrid clouds, Performance Measurement, Performance metrics, SMB
SQLCODE 30 on fetch SQLRPGLE
So here’s what I found: I took a deeper look in the dump and noticed the first two values from the select (zclco and zcmco) were being placed in the fields wbroker and wagent in the ClaimRecDS. As you can see, those fields are clearly in the middle of the data structure. I decided to [...]
View Answer
| December 29, 2011 2:12 PM
coalesce, NULL values, SQL, SQLRPGLE
So here’s what I found: I took a deeper look in the dump and noticed the first two values from the select (zclco and zcmco) were being placed in the fields wbroker and wagent in the ClaimRecDS. As you can see, those fields are clearly in the middle of the data structure. I decided to [...]
View Answer
| December 29, 2011 2:12 PM
coalesce, NULL values, SQL, SQLRPGLE
How to get into the BPM Field
Hi, BPM is really turning into a technology field, these days. It requires a strong knowledge of things like Process Design and Re-Engineering as a foundation but it also requires detailed knowledge of things like BPM Tools, Workflow Tools, Rules Engines, Scripting/Coding and so much more. Even the simplest Workflow Tools require some level of [...]
View Answer
| December 28, 2011 7:09 PM
BPM, IT training
Hi, BPM is really turning into a technology field, these days. It requires a strong knowledge of things like Process Design and Re-Engineering as a foundation but it also requires detailed knowledge of things like BPM Tools, Workflow Tools, Rules Engines, Scripting/Coding and so much more. Even the simplest Workflow Tools require some level of [...]
View Answer
| December 28, 2011 7:09 PM
BPM, IT training
How can I find all the mac address on a LAN?
Finding all available MAC addresses on your network can be a tedious task, especially if your clients are running firewall software that blocks requested initiated from other hosts. Despite that, a quick and easy search on Google.com, e.g ‘LAN MAC address scanner’ will reveal a number of software products that you can use to achieve [...]
View Answer
| December 28, 2011 4:34 AM
LAN, MAC address, VB.NET
Finding all available MAC addresses on your network can be a tedious task, especially if your clients are running firewall software that blocks requested initiated from other hosts. Despite that, a quick and easy search on Google.com, e.g ‘LAN MAC address scanner’ will reveal a number of software products that you can use to achieve [...]
View Answer
| December 28, 2011 4:34 AM
LAN, MAC address, VB.NET
