I have a table unload query, which is of length 33, But I need the output file length 80, which means 47 bytes extra..
You tagged your questions with “DB2″ … > depending on what you are using to unload your data, you could append 47 spaces to the end of the records example SELECT …,SPACE(47) > modify the result of the unload after the fact, use REXX or something to add the required number of spaces. > if [...]
View Answer
| November 1, 2011 8:47 PM
DB2
You tagged your questions with “DB2″ … > depending on what you are using to unload your data, you could append 47 spaces to the end of the records example SELECT …,SPACE(47) > modify the result of the unload after the fact, use REXX or something to add the required number of spaces. > if [...]
View Answer
| November 1, 2011 8:47 PM
DB2
Components and cables to design/build a network
Sounds like a great undertaking… 1) Good design states that you should plan for around 10-25% growth, so 80 users will mean you’ll need about 100+ potential “network connections” (80 + 25% (20) = 100) 2) Divisions = VLANs = Subnets: If you wish to segregate your Admin, Sales and Design folks from being able [...]
View Answer
| October 28, 2011 7:14 PM
Cables, Data transfer, Network, Network design, Routers, Switches
Sounds like a great undertaking… 1) Good design states that you should plan for around 10-25% growth, so 80 users will mean you’ll need about 100+ potential “network connections” (80 + 25% (20) = 100) 2) Divisions = VLANs = Subnets: If you wish to segregate your Admin, Sales and Design folks from being able [...]
View Answer
| October 28, 2011 7:14 PM
Cables, Data transfer, Network, Network design, Routers, Switches
How can a message board moderator find out my personal email address?
You can find out who the moderator is through the school campus because since he was a moderator, he had to have some type of status to hold that position of responsibility, it is not something that is just given to anyone. As to your email, there are a few ways, like WHOIS. Your IP [...]
View Answer
| October 26, 2011 1:32 PM
IP address, Networking, privacy, Security
You can find out who the moderator is through the school campus because since he was a moderator, he had to have some type of status to hold that position of responsibility, it is not something that is just given to anyone. As to your email, there are a few ways, like WHOIS. Your IP [...]
View Answer
| October 26, 2011 1:32 PM
IP address, Networking, privacy, Security
DB2 Join Query Error: DECFLOAT
SQL Code -420 means, A string argument did not conform to the requirements of the function. For example, a character string passed to the DECIMAL function did not conform to the rules for forming an SQL integer or decimal constant. Verify whether you are receiving the data to correct variable. Pradeep.
View Answer
| October 24, 2011 2:15 PM
IBM DB2
SQL Code -420 means, A string argument did not conform to the requirements of the function. For example, a character string passed to the DECIMAL function did not conform to the rules for forming an SQL integer or decimal constant. Verify whether you are receiving the data to correct variable. Pradeep.
View Answer
| October 24, 2011 2:15 PM
IBM DB2
Loop is seen on router but line protocol is down
please checks as below step by step. 1. If Wire connection please set manual IP in your computer as same series. And then see what happen. 2. If wireless then please right button click on wireless icon then you will see Open Network and Sharing Center. Click here then you will see full map of [...]
View Answer
| October 19, 2011 2:18 PM
Data link protocols, LOOP statement, Routers
please checks as below step by step. 1. If Wire connection please set manual IP in your computer as same series. And then see what happen. 2. If wireless then please right button click on wireless icon then you will see Open Network and Sharing Center. Click here then you will see full map of [...]
View Answer
| October 19, 2011 2:18 PM
Data link protocols, LOOP statement, Routers
Free IT Book: Demystifying the Virtual Desktop
http://itknowledgeexchange.techtarget.com/itanswers/extend-hdd/#viewquestion http://itknowledgeexchange.techtarget.com/itanswers/extend-hdd/ hope to win
View Answer
| October 18, 2011 4:36 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
http://itknowledgeexchange.techtarget.com/itanswers/extend-hdd/#viewquestion http://itknowledgeexchange.techtarget.com/itanswers/extend-hdd/ hope to win
View Answer
| October 18, 2011 4:36 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
Free SQL software with interface to enter data
You could use <a href=”http://www.openoffice.org/”>OpenOffice’s</a> Base. Base is similar to Access, but is free. Here’s a guide in case you decide to use it: <a href=”http://wiki.services.openoffice.org/w/images/3/3c/0108GS33-GettingStartedWithBase.pdf”>Getting Started with Base (OpenOffice.org’s Database Component)</a> (PDF)
View Answer
| October 17, 2011 4:17 PM
Data entry, Free software, Freeware, SQL, SQL Query
You could use <a href=”http://www.openoffice.org/”>OpenOffice’s</a> Base. Base is similar to Access, but is free. Here’s a guide in case you decide to use it: <a href=”http://wiki.services.openoffice.org/w/images/3/3c/0108GS33-GettingStartedWithBase.pdf”>Getting Started with Base (OpenOffice.org’s Database Component)</a> (PDF)
View Answer
| October 17, 2011 4:17 PM
Data entry, Free software, Freeware, SQL, SQL Query
Crystal Report based on sql query with more than two tables
its very easy u have to use below code for ur project try { TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; cr.Load(“C:\Users\NOOR-UL-AIN\Documents\Visual Studio 10\Projects\invoice\invoice\commercial invoice\commercial invoice\MyReport.rpt”); crConnectionInfo.ServerName = “your server name”; crConnectionInfo.DatabaseName = “database”; crConnectionInfo.UserID = “userid”; crConnectionInfo.Password = “password”; CrTables = cr.Database.Tables ; foreach [...]
View Answer
| October 16, 2011 9:54 AM
C# .NET, Crystal Report, Visual Studio 2008
its very easy u have to use below code for ur project try { TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; cr.Load(“C:\Users\NOOR-UL-AIN\Documents\Visual Studio 10\Projects\invoice\invoice\commercial invoice\commercial invoice\MyReport.rpt”); crConnectionInfo.ServerName = “your server name”; crConnectionInfo.DatabaseName = “database”; crConnectionInfo.UserID = “userid”; crConnectionInfo.Password = “password”; CrTables = cr.Database.Tables ; foreach [...]
View Answer
| October 16, 2011 9:54 AM
C# .NET, Crystal Report, Visual Studio 2008
EXTENDED: IT Scripts Contest now ends October 17
IT Scripts. If i win, i promise, i’ll start scripting (even in 3D), because now, i’m too busy in coding real stuff ! lol )
View Answer
| October 13, 2011 2:46 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Scripts, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
IT Scripts. If i win, i promise, i’ll start scripting (even in 3D), because now, i’m too busy in coding real stuff ! lol )
View Answer
| October 13, 2011 2:46 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Scripts, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Tried to go larger than storage limit for object OBJECTNM OBJECTNM
Adding some more information about Physical file.. This is a Keyed Physical file and It doesn’t have any logical files.
View Answer
| October 12, 2011 4:37 AM
AS/400, AS/400 objects, DB2, iSeries, iSeries data center
Adding some more information about Physical file.. This is a Keyed Physical file and It doesn’t have any logical files.
View Answer
| October 12, 2011 4:37 AM
AS/400, AS/400 objects, DB2, iSeries, iSeries data center
Free IT Book: IP Networking
just answered Users not receiving alerts to new General Discussion – http://itknowledgeexchange.techtarget.com/itanswers/users-not-receiving-alerts-to-new-general-discussion/#viewquestion hope to win IP Networking book
View Answer
| October 4, 2011 7:37 PM
AS/400, Business Intelligence, Channel, CIO, Contests, 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
just answered Users not receiving alerts to new General Discussion – http://itknowledgeexchange.techtarget.com/itanswers/users-not-receiving-alerts-to-new-general-discussion/#viewquestion hope to win IP Networking book
View Answer
| October 4, 2011 7:37 PM
AS/400, Business Intelligence, Channel, CIO, Contests, 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
Corrupt File on Windows Server 2003
Hi Jennifer, Please run Chkdsk utility. Follow the articles for more help: http://technet.microsoft.com/en-us/library/aa997189(EXCHG.65).aspx http://technet.microsoft.com/en-us/library/cc755829(WS.10).aspx Hope it works. Thank you Anil <a href=”http://www.lepide.com/”>LEPIDE</a>
View Answer
| October 4, 2011 9:56 AM
Corrupt Database, Data corruption, Windows Server 2003, Windows Server 2003 error messages
Hi Jennifer, Please run Chkdsk utility. Follow the articles for more help: http://technet.microsoft.com/en-us/library/aa997189(EXCHG.65).aspx http://technet.microsoft.com/en-us/library/cc755829(WS.10).aspx Hope it works. Thank you Anil <a href=”http://www.lepide.com/”>LEPIDE</a>
View Answer
| October 4, 2011 9:56 AM
Corrupt Database, Data corruption, Windows Server 2003, Windows Server 2003 error messages
Crystal Reports Value conversion into words (as an indian regulation)
Plz Tell me how To wrap marathi word in next Line in crystal report
View Answer
| October 3, 2011 4:50 AM
Crystal Reports
Plz Tell me how To wrap marathi word in next Line in crystal report
View Answer
| October 3, 2011 4:50 AM
Crystal Reports
PHP implementation
While PHP is by no means my area of expertise, I did do a little searching for you and found a pretty good website for an overall gist PHP setup and utilization. The website is <a href=”http://www.oxxus.net/tutorials/php”>Oxxus</a> and seems to provide some pretty good information. As far as using with an I Series server, it [...]
View Answer
| October 1, 2011 7:48 AM
PHP, PHP implementation, PHP installation, PHP scripts
While PHP is by no means my area of expertise, I did do a little searching for you and found a pretty good website for an overall gist PHP setup and utilization. The website is <a href=”http://www.oxxus.net/tutorials/php”>Oxxus</a> and seems to provide some pretty good information. As far as using with an I Series server, it [...]
View Answer
| October 1, 2011 7:48 AM
PHP, PHP implementation, PHP installation, PHP scripts
Open IT Forum: Does the Windows 8 secure boot and Linux clash affect you?
Beyond what my blog post states, that Melanie referenced, even if Microsoft attempts to take out the competition, there’s a lot of legal issues that are going to (and already have) arisen. As linked in my post: http://www.zdnet.com.au/linux-users-threaten-microsoft-with-accc-339323063.htm People are already threatening to sue Microsoft for anti-trust violations if Secure Boot eliminates the Linux possibility. [...]
View Answer
| September 29, 2011 2:38 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows 8, Windows Server
Beyond what my blog post states, that Melanie referenced, even if Microsoft attempts to take out the competition, there’s a lot of legal issues that are going to (and already have) arisen. As linked in my post: http://www.zdnet.com.au/linux-users-threaten-microsoft-with-accc-339323063.htm People are already threatening to sue Microsoft for anti-trust violations if Secure Boot eliminates the Linux possibility. [...]
View Answer
| September 29, 2011 2:38 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows 8, Windows Server
VSAM versus DB2 in CPU consumption
Thank you all for the comments but I was not clear about my problem description. My company has already made the decision to convert several COBOL/VSAM legacy systems to COBOL/DB2 after evaluating all their advantages and disadvantages. My job now is estimate how much we have increase the CPU to define the budget. We have [...]
View Answer
| September 27, 2011 7:44 PM
AS/400 DB2, DB2, VSAM, z/OS CPU consumption
Thank you all for the comments but I was not clear about my problem description. My company has already made the decision to convert several COBOL/VSAM legacy systems to COBOL/DB2 after evaluating all their advantages and disadvantages. My job now is estimate how much we have increase the CPU to define the budget. We have [...]
View Answer
| September 27, 2011 7:44 PM
AS/400 DB2, DB2, VSAM, z/OS CPU consumption
Crystal Reports XI reports
Good luck with the book,everyone always brings this up! Enjoy http://www.nikemallchina.com, Retail and wholesale NIKE、Adidas’s running shoes, soccer shoes, basketball shoes,and so on.
View Answer
| September 27, 2011 8:10 AM
Crystal Report XI, Crystal Reports, Windows Server 2003
Good luck with the book,everyone always brings this up! Enjoy http://www.nikemallchina.com, Retail and wholesale NIKE、Adidas’s running shoes, soccer shoes, basketball shoes,and so on.
View Answer
| September 27, 2011 8:10 AM
Crystal Report XI, Crystal Reports, Windows Server 2003
Open IT Forum: Will HP be a worthy cloud contender?
Good luck with the book,everyone always brings this up! Enjoy http://www.nikemallchina.com, Retail and wholesale NIKE、Adidas’s running shoes, soccer shoes, basketball shoes,and so on.
View Answer
| September 27, 2011 8:01 AM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, CRM, Database, DataCenter, Development, Exchange, Hewlett-Packard, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Good luck with the book,everyone always brings this up! Enjoy http://www.nikemallchina.com, Retail and wholesale NIKE、Adidas’s running shoes, soccer shoes, basketball shoes,and so on.
View Answer
| September 27, 2011 8:01 AM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, CRM, Database, DataCenter, Development, Exchange, Hewlett-Packard, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Open IT Forum: Goals to round out 2011
Open IT Forum: Goals to round out 2011 – The goals that have been set for our department to finish out this year (2011) and move into 2012 are simple; establish a base line of where we are currently with our software (back office) and begin the planning to fully implement the new back office [...]
View Answer
| September 26, 2011 1:26 PM
AS/400, Bounties, Business Intelligence, Channel, CIO, 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
Open IT Forum: Goals to round out 2011 – The goals that have been set for our department to finish out this year (2011) and move into 2012 are simple; establish a base line of where we are currently with our software (back office) and begin the planning to fully implement the new back office [...]
View Answer
| September 26, 2011 1:26 PM
AS/400, Bounties, Business Intelligence, Channel, CIO, 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
Merge two datasets in a DO loop
data one; input store sale1 sale2 sale3 sale4 sale5; cards; 1 100 200 300 400 500 2 150 250 350 450 550 ; run; data two; input store sale1 sale2 sale3 sale4 sale5; cards; 1 200 300 400 500 600 2 250 350 450 550 650 3 380 370 840 560 350 4 230 340 [...]
View Answer
| September 21, 2011 10:52 AM
DO LOOP statement, MERGE statement, SAP Business Intelligence, SAS, SAS Business Intelligence software, SAS Data Analysis
data one; input store sale1 sale2 sale3 sale4 sale5; cards; 1 100 200 300 400 500 2 150 250 350 450 550 ; run; data two; input store sale1 sale2 sale3 sale4 sale5; cards; 1 200 300 400 500 600 2 250 350 450 550 650 3 380 370 840 560 350 4 230 340 [...]
View Answer
| September 21, 2011 10:52 AM
DO LOOP statement, MERGE statement, SAP Business Intelligence, SAS, SAS Business Intelligence software, SAS Data Analysis
