RPGLE Embedded SQL Not null
see this article <a href=”http://www.itjungle.com/fhg/fhg102908-story02.html”>Meaningful Names for Null Indicators</a>
View Answer
| June 20, 2011 5:13 PM
AS/400, Embedded SQL, RPGLE, SQL
see this article <a href=”http://www.itjungle.com/fhg/fhg102908-story02.html”>Meaningful Names for Null Indicators</a>
View Answer
| June 20, 2011 5:13 PM
AS/400, Embedded SQL, RPGLE, SQL
Free IT Book: Achieving Extreme Performance with Oracle Exadata
seeing as no one’s done this can I have the book anyway?
View Answer
| June 20, 2011 12:47 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exadata Database Machine, Exchange, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
seeing as no one’s done this can I have the book anyway?
View Answer
| June 20, 2011 12:47 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exadata Database Machine, Exchange, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Problem Querying SQL table from PHP
Well, we resolved the issue. Two of the columns were nvarchar(max) due to SQL DBA’s extreme laziness (that’s me). Once I throttled that down to a ‘mere’ 500 each, it worked.
View Answer
| June 17, 2011 3:22 PM
PHP, SQL 2008, SQL Server 2008, SQL tables
Well, we resolved the issue. Two of the columns were nvarchar(max) due to SQL DBA’s extreme laziness (that’s me). Once I throttled that down to a ‘mere’ 500 each, it worked.
View Answer
| June 17, 2011 3:22 PM
PHP, SQL 2008, SQL Server 2008, SQL tables
How to use API’s?
see article by Bob Cozzi <a href=”http://systeminetwork.com/node/26454″>Regular Expressions Revisited</a>
View Answer
| June 17, 2011 11:22 AM
API, REGCOMP, REGEXEC, REGFREE, RPGLE
see article by Bob Cozzi <a href=”http://systeminetwork.com/node/26454″>Regular Expressions Revisited</a>
View Answer
| June 17, 2011 11:22 AM
API, REGCOMP, REGEXEC, REGFREE, RPGLE
Access 2010 database query
You will probably need to do this with mutlple queries. I’m just thinking without testing it and maybe this is over simplifed right now; but it will get you thinking. I would probably store the level in the roster table and a date when it was last changed. Then, make a query that would get [...]
View Answer
| June 16, 2011 2:33 PM
Access 2010, Access Database, Access Database Attachments, Access query
You will probably need to do this with mutlple queries. I’m just thinking without testing it and maybe this is over simplifed right now; but it will get you thinking. I would probably store the level in the roster table and a date when it was last changed. Then, make a query that would get [...]
View Answer
| June 16, 2011 2:33 PM
Access 2010, Access Database, Access Database Attachments, Access query
Access Database Splitting
Did you make sure that everyone is opening it in Shared mode? Also, you may want to make sure everyone has the same version and SP installed.
View Answer
| June 16, 2011 1:43 PM
Access 2007, Access Database, Access Database Design
Did you make sure that everyone is opening it in Shared mode? Also, you may want to make sure everyone has the same version and SP installed.
View Answer
| June 16, 2011 1:43 PM
Access 2007, Access Database, Access Database Design
Open IT Forum: What tech blogs and Twitter feeds do you follow?
Oracle_Edu
View Answer
| June 14, 2011 1:54 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Blogs, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
Oracle_Edu
View Answer
| June 14, 2011 1:54 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Blogs, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
Moving an array with controller to another server
yup. You likely won’t have any data on the disc’s when you fire the new server up though. It depends on how and where the information for the array/controller is and how it will behave with any differences in hardware in the new location. I would stronly not reccommend this.
View Answer
| June 13, 2011 1:17 PM
Array processing, RAID 10, RAID Array, RAID configuration, RAID controllers, Server Architectures
yup. You likely won’t have any data on the disc’s when you fire the new server up though. It depends on how and where the information for the array/controller is and how it will behave with any differences in hardware in the new location. I would stronly not reccommend this.
View Answer
| June 13, 2011 1:17 PM
Array processing, RAID 10, RAID Array, RAID configuration, RAID controllers, Server Architectures
Creating new domain user in Windows Server 2003 and 2008
Hope this will be helpful Please find a script at this link : http://searchwindowsserver.techtarget.com/tip/Automate-Active-Directory-tasks-with-scripts
View Answer
| June 13, 2011 11:17 AM
Automation, Domain Users, Exchange administration, Windows Server 2003, Windows Server 2008
Hope this will be helpful Please find a script at this link : http://searchwindowsserver.techtarget.com/tip/Automate-Active-Directory-tasks-with-scripts
View Answer
| June 13, 2011 11:17 AM
Automation, Domain Users, Exchange administration, Windows Server 2003, Windows Server 2008
Creating a route to allow SEP Live updates through firewall
In your HTTP Proxy Action configuration, add *.symantec.com to the HTTP Request->URL Paths.
View Answer
| June 9, 2011 6:47 PM
Firewalls, HTTP, WatchGuard, Windows Server 2003 R2
In your HTTP Proxy Action configuration, add *.symantec.com to the HTTP Request->URL Paths.
View Answer
| June 9, 2011 6:47 PM
Firewalls, HTTP, WatchGuard, Windows Server 2003 R2
Dell PowerEdge 6800 drives in array corrupted
It could be a chassis issue, but you need to get much more specific than that. When the system boots, make note of ALL firmware revisions of BIOS, Controller, Backplane, etc. – everything you see at boot time. Dell has several firmware fixes for different parts of that system ranging from Optional to Urgent. If [...]
View Answer
| June 9, 2011 4:20 PM
Arrays, Corrupt Database, Dell PowerEdge, Dell PowerEdge Performance
It could be a chassis issue, but you need to get much more specific than that. When the system boots, make note of ALL firmware revisions of BIOS, Controller, Backplane, etc. – everything you see at boot time. Dell has several firmware fixes for different parts of that system ranging from Optional to Urgent. If [...]
View Answer
| June 9, 2011 4:20 PM
Arrays, Corrupt Database, Dell PowerEdge, Dell PowerEdge Performance
Embedded SQL using SUM or some other method to total up qty and display 1 unique record
select ser#, <b>count(*) </b> as count, <b>sum(qty)</b> as total from file <b>group by </b>ser#
View Answer
| June 9, 2011 1:44 PM
Embedded SQL, SQL, SQL Select, SQL Select statement problem, SQLRPG
select ser#, <b>count(*) </b> as count, <b>sum(qty)</b> as total from file <b>group by </b>ser#
View Answer
| June 9, 2011 1:44 PM
Embedded SQL, SQL, SQL Select, SQL Select statement problem, SQLRPG
Open IT Forum: What’s your weapon of choice for personal or enterprise storage?
Dropbox works perfectly for personal use!
View Answer
| June 8, 2011 9:00 AM
Amazon, Box.net, Cloud storage, Dropbox, Enterprise content management, Mozy, Open IT Forum, Storage
Dropbox works perfectly for personal use!
View Answer
| June 8, 2011 9:00 AM
Amazon, Box.net, Cloud storage, Dropbox, Enterprise content management, Mozy, Open IT Forum, Storage
Free IT Book: The Data Warehouse Mentor
twitted http://twitter.com/#!/batye1
View Answer
| June 7, 2011 6:29 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
twitted http://twitter.com/#!/batye1
View Answer
| June 7, 2011 6:29 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
CCIE job search
I don’t think that age would be a factor, provided that you have the knowledge and experience needed for the job. Do you have any experience with this field, or are you wanting to dive in from scratch? do u have any previous experience in networking and by what u said i think u dont [...]
View Answer
| June 7, 2011 1:53 PM
CCIE, CCIE consultancy, CCIE training, Certified Software Quality Analyst
I don’t think that age would be a factor, provided that you have the knowledge and experience needed for the job. Do you have any experience with this field, or are you wanting to dive in from scratch? do u have any previous experience in networking and by what u said i think u dont [...]
View Answer
| June 7, 2011 1:53 PM
CCIE, CCIE consultancy, CCIE training, Certified Software Quality Analyst
Adding a scheduled job
I do not believe you can add an automatic ENTER key. But, you can change your program to check to see if it is running in BATCH mode and then ignore the process that requires the ENTER key.
View Answer
| June 7, 2011 12:41 PM
AS/400 job scheduler, AS/400 jobs, Call PGM Command, Job scheduling
I do not believe you can add an automatic ENTER key. But, you can change your program to check to see if it is running in BATCH mode and then ignore the process that requires the ENTER key.
View Answer
| June 7, 2011 12:41 PM
AS/400 job scheduler, AS/400 jobs, Call PGM Command, Job scheduling
What FTP server for Apache virtual host server?
You could use pureftp and its virtual host configuration as outlined below. http://download.pureftpd.org/pub/pure-ftpd/doc/README.Virtual-Users
View Answer
| June 5, 2011 8:15 AM
Apache, FTP, FTP Server, Ubuntu, Virtual Hosting
You could use pureftp and its virtual host configuration as outlined below. http://download.pureftpd.org/pub/pure-ftpd/doc/README.Virtual-Users
View Answer
| June 5, 2011 8:15 AM
Apache, FTP, FTP Server, Ubuntu, Virtual Hosting
Delete contents of a folder tree with a kill statement
just bash in the code for delete into command line or VBS etc.. with it pointed to the directory such as C:folders with crap* where the * in windows is the wildcard for anything in this location. Job done.
View Answer
| June 3, 2011 1:03 PM
Batch files, Batch jobs, VB script, Visual Basic Script
just bash in the code for delete into command line or VBS etc.. with it pointed to the directory such as C:folders with crap* where the * in windows is the wildcard for anything in this location. Job done.
View Answer
| June 3, 2011 1:03 PM
Batch files, Batch jobs, VB script, Visual Basic Script
Round robin for data syncing with Windows Server 2003 SP2
Don’t. Set up DFS correctly and it will do all of this in one easy move. It won’t do round robin but will be site aware and will replicate the data between the boxes if you want it to. Round Robin is not a good idea as if the server dies connections will still be [...]
View Answer
| June 3, 2011 12:55 PM
Data Sync Manager, Data synchronization, Round Robin, Windows Server 2003, Windows Server 2003 SP2
Don’t. Set up DFS correctly and it will do all of this in one easy move. It won’t do round robin but will be site aware and will replicate the data between the boxes if you want it to. Round Robin is not a good idea as if the server dies connections will still be [...]
View Answer
| June 3, 2011 12:55 PM
Data Sync Manager, Data synchronization, Round Robin, Windows Server 2003, Windows Server 2003 SP2
Rolling back Windows Server 2003 in bulk to a restore point
Dear Lord! You could potentially use powershell for this or the command line but you would need to google/learn more on either in alot of detail. Chances are though that you could have them done manually before you find a way of automating it.
View Answer
| June 3, 2011 12:35 PM
Automation, Restore Database, Windows Server 2003, Windows Server 2003 administration, Windows server administration
Dear Lord! You could potentially use powershell for this or the command line but you would need to google/learn more on either in alot of detail. Chances are though that you could have them done manually before you find a way of automating it.
View Answer
| June 3, 2011 12:35 PM
Automation, Restore Database, Windows Server 2003, Windows Server 2003 administration, Windows server administration
