Edit a text file with VBA
You could use a script like this. Actually, it does not “replace” the line, but reads the complete file and writes the modified text back. It could take some time (and resources) to process large files this way. <pre>Const ForReading = 1 Const ForWriting = 2 Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile("C:your_file.txt", ForReading) [...]
View Answer
| May 8, 2013 1:58 PM
Access 2007, Text manipulation, VB, VBA
You could use a script like this. Actually, it does not “replace” the line, but reads the complete file and writes the modified text back. It could take some time (and resources) to process large files this way. <pre>Const ForReading = 1 Const ForWriting = 2 Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile("C:your_file.txt", ForReading) [...]
View Answer
| May 8, 2013 1:58 PM
Access 2007, Text manipulation, VB, VBA
Crystal Reports Calculations & Formulas
What would be the formula to display the UnitPrice + 10% increase; using Crystal Report
View Answer
| January 27, 2010 11:46 PM
Business Objects, Crystal Reports, Crystal Reports XI
What would be the formula to display the UnitPrice + 10% increase; using Crystal Report
View Answer
| January 27, 2010 11:46 PM
Business Objects, Crystal Reports, Crystal Reports XI
Need help executing MULTIPLE SQL extracts from a JCL
Sorry, I wasn’t reading closely. RUNSQLSTM is not a JCL command, I was thinking CL. ——— JCL & SQL & DB2 – are we talking MVS? To exec dynamic DB2 SQL statements in a batch job (JCL); try using DSNTEP2 : <pre> 001720 //** 001800 //STEP1 EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=EVEN 001810 //SYSPRINT DD SYSOUT=* 001900 //SYSTSPRT DD [...]
View Answer
| January 27, 2010 4:14 PM
DB2, JCL, SELECT statement, SQL
Sorry, I wasn’t reading closely. RUNSQLSTM is not a JCL command, I was thinking CL. ——— JCL & SQL & DB2 – are we talking MVS? To exec dynamic DB2 SQL statements in a batch job (JCL); try using DSNTEP2 : <pre> 001720 //** 001800 //STEP1 EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=EVEN 001810 //SYSPRINT DD SYSOUT=* 001900 //SYSTSPRT DD [...]
View Answer
| January 27, 2010 4:14 PM
DB2, JCL, SELECT statement, SQL
Why does the keyword END is not accepted at the end of a stored proc ?
The message is saying that the semi-colon was encountered where one wasn’t expected. It goes on to say that CASE should be the token that would be after END under the circumstances. I suspect that the full source member is not actually a CREATE PROCEDURE operation. If it’s instead a basic SQL statement, then it’s [...]
View Answer
| January 26, 2010 12:13 AM
DB2, iSeries, SQL
The message is saying that the semi-colon was encountered where one wasn’t expected. It goes on to say that CASE should be the token that would be after END under the circumstances. I suspect that the full source member is not actually a CREATE PROCEDURE operation. If it’s instead a basic SQL statement, then it’s [...]
View Answer
| January 26, 2010 12:13 AM
DB2, iSeries, SQL
Data transfer from DB2 (AS400) TO SQL SERVER 2005
More information would be helpful. In a nutshell you’ll need to use SQL Server Integration Services (SSIS) to do the work. On your workstation (or the server) install the AS400 drivers. Then open the Business Intelligence Development Studio (BIDS) and create a new SSIS package. Then use a data flow task to copy the data [...]
View Answer
| January 25, 2010 6:07 AM
AS/400 data transfer, DB2, DB2 Data Transfer, DB2 to SQL Server Data Transfer, send any detail help please, SQL Server 2005
More information would be helpful. In a nutshell you’ll need to use SQL Server Integration Services (SSIS) to do the work. On your workstation (or the server) install the AS400 drivers. Then open the Business Intelligence Development Studio (BIDS) and create a new SSIS package. Then use a data flow task to copy the data [...]
View Answer
| January 25, 2010 6:07 AM
AS/400 data transfer, DB2, DB2 Data Transfer, DB2 to SQL Server Data Transfer, send any detail help please, SQL Server 2005
What Hardware is required for implementing a wireless lan for a convention center?
Barry, The LA convention center should already have all that in place and available for rent/usage during your event. That said in order to put your own WiFi system into place you’ll need to bunch of WiFi access ports and a network router to route the network traffic from the wireless network to the public [...]
View Answer
| January 23, 2010 3:25 PM
802.11, 802.11n, Network hardware, RFID, Wireless LAN, Wireless Network Implementation, Wireless networking, Wireless networks
Barry, The LA convention center should already have all that in place and available for rent/usage during your event. That said in order to put your own WiFi system into place you’ll need to bunch of WiFi access ports and a network router to route the network traffic from the wireless network to the public [...]
View Answer
| January 23, 2010 3:25 PM
802.11, 802.11n, Network hardware, RFID, Wireless LAN, Wireless Network Implementation, Wireless networking, Wireless networks
how to handle single value and multiple values columns at the time of display in C#
To get customer info with a count of how many items they ordered: SELECT t1.customerName, t1.address, t1.phone, SUM(t2.qty) FROM t1 INNER JOIN t2 ON t1.customer = t2.customer GROUP BY t1.customerName, t1.address, t1.phone I’m assuming that t1 and t2 have some customer number in common. If you want all the customer info and all of the [...]
View Answer
| January 22, 2010 5:54 AM
.NET, C#, Crystal Reports
To get customer info with a count of how many items they ordered: SELECT t1.customerName, t1.address, t1.phone, SUM(t2.qty) FROM t1 INNER JOIN t2 ON t1.customer = t2.customer GROUP BY t1.customerName, t1.address, t1.phone I’m assuming that t1 and t2 have some customer number in common. If you want all the customer info and all of the [...]
View Answer
| January 22, 2010 5:54 AM
.NET, C#, Crystal Reports
export VB6 report in pdf format.
Your going to have to use a third party DLL. I would reccomend avoiding this all togetehr and instead installing something like: <a href=”http://sourceforge.net/projects/pdfcreator/”>PDFCreator</a> on the users computer so they can print the crystal report to pdf.
View Answer
| January 21, 2010 8:59 PM
Access Database, Crystal Reports, Microsoft Access, VB6, Visual Basic
Your going to have to use a third party DLL. I would reccomend avoiding this all togetehr and instead installing something like: <a href=”http://sourceforge.net/projects/pdfcreator/”>PDFCreator</a> on the users computer so they can print the crystal report to pdf.
View Answer
| January 21, 2010 8:59 PM
Access Database, Crystal Reports, Microsoft Access, VB6, Visual Basic
how to open crystal report in new window
Here is how I would accomplish this. When the button is clicked to view the report, do this: Response.Write(“<script type=’text/javascript’>window.open(‘../ViewReport.aspx?parameter=” & strValue & “‘, ‘_blank’, ‘width=800,height=600′);</script>”) Now build ViewReport.aspx with the CR Viewer on it. In the page load event, read the parameters out of Request.QueryString feed them to the report. Now when the click [...]
View Answer
| January 21, 2010 8:15 PM
ASP.NET 2.0, C#, Crystal Reports, Crystal Reports XI
Here is how I would accomplish this. When the button is clicked to view the report, do this: Response.Write(“<script type=’text/javascript’>window.open(‘../ViewReport.aspx?parameter=” & strValue & “‘, ‘_blank’, ‘width=800,height=600′);</script>”) Now build ViewReport.aspx with the CR Viewer on it. In the page load event, read the parameters out of Request.QueryString feed them to the report. Now when the click [...]
View Answer
| January 21, 2010 8:15 PM
ASP.NET 2.0, C#, Crystal Reports, Crystal Reports XI
is there any process to store the data of dataqueue
This is link to <a href=”http://home.windstream.net/craigru/jcrcmd2.html#top_tag”>Craig Rutledge JCRCMDS</a>. There is a tool to display dtaq-entries. You can download JCRCMDS and install them. You can use the source of the retrieve-program and write the entries into a file, which you can save. ====================================================== In general, there are five ways to “store” the entries in a data [...]
View Answer
| January 21, 2010 7:38 AM
AS/400, DB2
This is link to <a href=”http://home.windstream.net/craigru/jcrcmd2.html#top_tag”>Craig Rutledge JCRCMDS</a>. There is a tool to display dtaq-entries. You can download JCRCMDS and install them. You can use the source of the retrieve-program and write the entries into a file, which you can save. ====================================================== In general, there are five ways to “store” the entries in a data [...]
View Answer
| January 21, 2010 7:38 AM
AS/400, DB2
String Field Comparisons
If you have a defined list of values for your string field, a simple ‘if..then..else’ should suffice i.e <pre> if {StringField} = “XXX” then “Code1″ else if {StringField} = “YYY” then “Code2″ else if {StringField} = “ZZZ” then “Code3″ else… else “ERROR : No Match Found) </pre> However if this used in multiple reports and [...]
View Answer
| January 19, 2010 7:21 AM
Crystal Reports, String manipulation
If you have a defined list of values for your string field, a simple ‘if..then..else’ should suffice i.e <pre> if {StringField} = “XXX” then “Code1″ else if {StringField} = “YYY” then “Code2″ else if {StringField} = “ZZZ” then “Code3″ else… else “ERROR : No Match Found) </pre> However if this used in multiple reports and [...]
View Answer
| January 19, 2010 7:21 AM
Crystal Reports, String manipulation
convert crystal reports version 8.5 to version 10
pls can u explain some error in crystal report to me any error u think of pls help me out
View Answer
| January 18, 2010 6:54 PM
Crystal Reports, Crystal Reports 10, Crystal Reports 8.5
pls can u explain some error in crystal report to me any error u think of pls help me out
View Answer
| January 18, 2010 6:54 PM
Crystal Reports, Crystal Reports 10, Crystal Reports 8.5
can anybody tell me how to know max sal in db2/400 means in pf
I am not familiar with max sal on the AS400, A PF has two maximum values. 1. Max Size – Which determines that maximum number of records 2. Max Mbrs – Which determines the maximum number of members in a PF. This is usually 1. Please let use know where you found this max sal [...]
View Answer
| January 18, 2010 6:29 PM
DB2, DB2/400, PF
I am not familiar with max sal on the AS400, A PF has two maximum values. 1. Max Size – Which determines that maximum number of records 2. Max Mbrs – Which determines the maximum number of members in a PF. This is usually 1. Please let use know where you found this max sal [...]
View Answer
| January 18, 2010 6:29 PM
DB2, DB2/400, PF
How do I convert time value in integer form to SAS time?
I know it’s an old post…. but I post this for reference. new_time= input(put(old_time, $6.),hhmmss8.); Hope this helps Manu
View Answer
| January 18, 2010 2:52 PM
SAS programming
I know it’s an old post…. but I post this for reference. new_time= input(put(old_time, $6.),hhmmss8.); Hope this helps Manu
View Answer
| January 18, 2010 2:52 PM
SAS programming
DB2 Unload and Load JCL using IBM utility
The first place you should look at the manuals and your coworkers. You need some education. You cannot be expected to know how to use DB2 just off the street. DB2 on z/OS is about the best there is, but it is complicated. Go to your boss and explain that you do not know DB2. [...]
View Answer
| April 19, 2013 5:55 PM
DB2, IBM Mainframe, JCL
The first place you should look at the manuals and your coworkers. You need some education. You cannot be expected to know how to use DB2 just off the street. DB2 on z/OS is about the best there is, but it is complicated. Go to your boss and explain that you do not know DB2. [...]
View Answer
| April 19, 2013 5:55 PM
DB2, IBM Mainframe, JCL
IT evaluation
It depends on the outcome you desire. What are you looking to accomplish? I do think a large contributor to weaknesses and gaps in IT is not looking at the bigger picture. TechTarget’s <a href=”http://SearchCIO.com”>SearchCIO.com</a> and <a href=”http://searchcio-midmarket.techtarget.com/”>SearchCIO-Midmarket.com</a> have some good info/resources on this.
View Answer
| January 14, 2010 1:36 PM
ERP, IT Business Alignment, IT Business Alignment in 2010, SAP
It depends on the outcome you desire. What are you looking to accomplish? I do think a large contributor to weaknesses and gaps in IT is not looking at the bigger picture. TechTarget’s <a href=”http://SearchCIO.com”>SearchCIO.com</a> and <a href=”http://searchcio-midmarket.techtarget.com/”>SearchCIO-Midmarket.com</a> have some good info/resources on this.
View Answer
| January 14, 2010 1:36 PM
ERP, IT Business Alignment, IT Business Alignment in 2010, SAP
Configuring Sales order linking to PO
I am investigating this also. It is call Third Party Processing in the documentation. The Item Category TAS in the Sales Order will create a Purchase Requisition with the Customer Delivery Address. You create a PO from the Purchase Req. It is not set up in my system, so I’m not sure how the Inventory [...]
View Answer
| January 14, 2010 11:08 AM
ERP, MySAP, mySAP Financials, R/3, SAP development
I am investigating this also. It is call Third Party Processing in the documentation. The Item Category TAS in the Sales Order will create a Purchase Requisition with the Customer Delivery Address. You create a PO from the Purchase Req. It is not set up in my system, so I’m not sure how the Inventory [...]
View Answer
| January 14, 2010 11:08 AM
ERP, MySAP, mySAP Financials, R/3, SAP development
copy files to a server
Please post more details, code snippets etc to provide a much better overview of what you’re trying accomplish.
View Answer
| January 13, 2010 10:00 PM
File transfers, Windows File Server, Windows Server
Please post more details, code snippets etc to provide a much better overview of what you’re trying accomplish.
View Answer
| January 13, 2010 10:00 PM
File transfers, Windows File Server, Windows Server
Reporting Services 2005
In order to resolve the error you need to ensure that the element http://localhost/reportserver in the rsreportserver.config is configured to the correct computer name. By default the rsreportserver.config file is in the directory C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer.
View Answer
| January 13, 2010 9:16 PM
Reporting, Reporting Services, Reporting Services 2005, SSRS, SSRS 2005
In order to resolve the error you need to ensure that the element http://localhost/reportserver in the rsreportserver.config is configured to the correct computer name. By default the rsreportserver.config file is in the directory C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer.
View Answer
| January 13, 2010 9:16 PM
Reporting, Reporting Services, Reporting Services 2005, SSRS, SSRS 2005
DB2 to SQL Server migration
Question 1 – They should have an AS400 Anaylst Question 2 – Same thing Our company has a product that converts DB2 from the AS/400 to SQL Server for .NET. We would be happy to provide that service for your client. Please let me know if you want to discuss this in more detail.
View Answer
| January 8, 2010 3:45 AM
DB2, SQL Server migration
Question 1 – They should have an AS400 Anaylst Question 2 – Same thing Our company has a product that converts DB2 from the AS/400 to SQL Server for .NET. We would be happy to provide that service for your client. Please let me know if you want to discuss this in more detail.
View Answer
| January 8, 2010 3:45 AM
DB2, SQL Server migration
