Skip to main content

[archive] Passing http address issue...

  • March 11, 2010
  • 9 replies
  • 0 views

[Migrated content. Thread originally posted on 10 March 2010]

I have the following statements (replaced a few characters in command with * for security) in a program:

INITIALIZE CMD-FLAGS.
COMPUTE CMD-FLAGS = CSYS-SHELL
CSYS-HIDDEN
CSYS-DESKTOP
CSYS-ASYNC.
INITIALIZE DATA-LINK.

STRING "START "
"http://**********.****.net/ReportServer/"
"Pages/******Viewer.aspx?/***** Server Reports/"
"DataDump&rs:Command=Render&PCRID="
DELIMITED BY SIZE
WS-BI-PCR-ID DELIMITED BY " "
INTO DATA-LINK.
CALL "C$SYSTEM" USING DATA-LINK
CMD-FLAGS.

When we look at the data-link variable in debug it has the full correct value in it. The issue comes in when the CALL statement happens. In Internet Explorer when the HTTP address stops at the "&" character. So all we get is everything up to the "DataDump" part of the address and nothing after. This of course is an invalid address so the page does not come up. I have tried to use HEX values for the "&" and that did not help. I have also put "&" in other places in the address and where ever the "&" is the HTTP address ends in IE.

Has anyone ever had issues passing HTTP address like this before?

9 replies

[Migrated content. Thread originally posted on 10 March 2010]

I have the following statements (replaced a few characters in command with * for security) in a program:

INITIALIZE CMD-FLAGS.
COMPUTE CMD-FLAGS = CSYS-SHELL
CSYS-HIDDEN
CSYS-DESKTOP
CSYS-ASYNC.
INITIALIZE DATA-LINK.

STRING "START "
"http://**********.****.net/ReportServer/"
"Pages/******Viewer.aspx?/***** Server Reports/"
"DataDump&rs:Command=Render&PCRID="
DELIMITED BY SIZE
WS-BI-PCR-ID DELIMITED BY " "
INTO DATA-LINK.
CALL "C$SYSTEM" USING DATA-LINK
CMD-FLAGS.

When we look at the data-link variable in debug it has the full correct value in it. The issue comes in when the CALL statement happens. In Internet Explorer when the HTTP address stops at the "&" character. So all we get is everything up to the "DataDump" part of the address and nothing after. This of course is an invalid address so the page does not come up. I have tried to use HEX values for the "&" and that did not help. I have also put "&" in other places in the address and where ever the "&" is the HTTP address ends in IE.

Has anyone ever had issues passing HTTP address like this before?
Use '&' instead of '&' in the URL. I hope this will fix your issue. You may need to convert some other special characters also.

[Migrated content. Thread originally posted on 10 March 2010]

I have the following statements (replaced a few characters in command with * for security) in a program:

INITIALIZE CMD-FLAGS.
COMPUTE CMD-FLAGS = CSYS-SHELL
CSYS-HIDDEN
CSYS-DESKTOP
CSYS-ASYNC.
INITIALIZE DATA-LINK.

STRING "START "
"http://**********.****.net/ReportServer/"
"Pages/******Viewer.aspx?/***** Server Reports/"
"DataDump&rs:Command=Render&PCRID="
DELIMITED BY SIZE
WS-BI-PCR-ID DELIMITED BY " "
INTO DATA-LINK.
CALL "C$SYSTEM" USING DATA-LINK
CMD-FLAGS.

When we look at the data-link variable in debug it has the full correct value in it. The issue comes in when the CALL statement happens. In Internet Explorer when the HTTP address stops at the "&" character. So all we get is everything up to the "DataDump" part of the address and nothing after. This of course is an invalid address so the page does not come up. I have tried to use HEX values for the "&" and that did not help. I have also put "&" in other places in the address and where ever the "&" is the HTTP address ends in IE.

Has anyone ever had issues passing HTTP address like this before?
Thanks for the idea but the same thing happens when using the method you suggested also.

Still stuck!!!

[Migrated content. Thread originally posted on 10 March 2010]

I have the following statements (replaced a few characters in command with * for security) in a program:

INITIALIZE CMD-FLAGS.
COMPUTE CMD-FLAGS = CSYS-SHELL
CSYS-HIDDEN
CSYS-DESKTOP
CSYS-ASYNC.
INITIALIZE DATA-LINK.

STRING "START "
"http://**********.****.net/ReportServer/"
"Pages/******Viewer.aspx?/***** Server Reports/"
"DataDump&rs:Command=Render&PCRID="
DELIMITED BY SIZE
WS-BI-PCR-ID DELIMITED BY " "
INTO DATA-LINK.
CALL "C$SYSTEM" USING DATA-LINK
CMD-FLAGS.

When we look at the data-link variable in debug it has the full correct value in it. The issue comes in when the CALL statement happens. In Internet Explorer when the HTTP address stops at the "&" character. So all we get is everything up to the "DataDump" part of the address and nothing after. This of course is an invalid address so the page does not come up. I have tried to use HEX values for the "&" and that did not help. I have also put "&" in other places in the address and where ever the "&" is the HTTP address ends in IE.

Has anyone ever had issues passing HTTP address like this before?
Thanks for the idea but the same thing happens when using the method you suggested also.

Still stuck!!!

[Migrated content. Thread originally posted on 10 March 2010]

I have the following statements (replaced a few characters in command with * for security) in a program:

INITIALIZE CMD-FLAGS.
COMPUTE CMD-FLAGS = CSYS-SHELL
CSYS-HIDDEN
CSYS-DESKTOP
CSYS-ASYNC.
INITIALIZE DATA-LINK.

STRING "START "
"http://**********.****.net/ReportServer/"
"Pages/******Viewer.aspx?/***** Server Reports/"
"DataDump&rs:Command=Render&PCRID="
DELIMITED BY SIZE
WS-BI-PCR-ID DELIMITED BY " "
INTO DATA-LINK.
CALL "C$SYSTEM" USING DATA-LINK
CMD-FLAGS.

When we look at the data-link variable in debug it has the full correct value in it. The issue comes in when the CALL statement happens. In Internet Explorer when the HTTP address stops at the "&" character. So all we get is everything up to the "DataDump" part of the address and nothing after. This of course is an invalid address so the page does not come up. I have tried to use HEX values for the "&" and that did not help. I have also put "&" in other places in the address and where ever the "&" is the HTTP address ends in IE.

Has anyone ever had issues passing HTTP address like this before?
Thanks for the idea but the same thing happens when using the method you suggested also.

Still stuck!!!

[Migrated content. Thread originally posted on 10 March 2010]

I have the following statements (replaced a few characters in command with * for security) in a program:

INITIALIZE CMD-FLAGS.
COMPUTE CMD-FLAGS = CSYS-SHELL
CSYS-HIDDEN
CSYS-DESKTOP
CSYS-ASYNC.
INITIALIZE DATA-LINK.

STRING "START "
"http://**********.****.net/ReportServer/"
"Pages/******Viewer.aspx?/***** Server Reports/"
"DataDump&rs:Command=Render&PCRID="
DELIMITED BY SIZE
WS-BI-PCR-ID DELIMITED BY " "
INTO DATA-LINK.
CALL "C$SYSTEM" USING DATA-LINK
CMD-FLAGS.

When we look at the data-link variable in debug it has the full correct value in it. The issue comes in when the CALL statement happens. In Internet Explorer when the HTTP address stops at the "&" character. So all we get is everything up to the "DataDump" part of the address and nothing after. This of course is an invalid address so the page does not come up. I have tried to use HEX values for the "&" and that did not help. I have also put "&" in other places in the address and where ever the "&" is the HTTP address ends in IE.

Has anyone ever had issues passing HTTP address like this before?
Try putting the http link itself in quotes, so that your START command reads something like START "thislink.is.quoted.com/.../helps".

[Migrated content. Thread originally posted on 10 March 2010]

I have the following statements (replaced a few characters in command with * for security) in a program:

INITIALIZE CMD-FLAGS.
COMPUTE CMD-FLAGS = CSYS-SHELL
CSYS-HIDDEN
CSYS-DESKTOP
CSYS-ASYNC.
INITIALIZE DATA-LINK.

STRING "START "
"http://**********.****.net/ReportServer/"
"Pages/******Viewer.aspx?/***** Server Reports/"
"DataDump&rs:Command=Render&PCRID="
DELIMITED BY SIZE
WS-BI-PCR-ID DELIMITED BY " "
INTO DATA-LINK.
CALL "C$SYSTEM" USING DATA-LINK
CMD-FLAGS.

When we look at the data-link variable in debug it has the full correct value in it. The issue comes in when the CALL statement happens. In Internet Explorer when the HTTP address stops at the "&" character. So all we get is everything up to the "DataDump" part of the address and nothing after. This of course is an invalid address so the page does not come up. I have tried to use HEX values for the "&" and that did not help. I have also put "&" in other places in the address and where ever the "&" is the HTTP address ends in IE.

Has anyone ever had issues passing HTTP address like this before?
Blacky thanks for the option...but when I do this I get a windows command box that appears and the command does not run and start IE.

I am getting close to the end of my rope, but you guys keep feeding me stuff and I will try it.

I want this solved but I have nothing left but to rely on the experts in this forum.

Thanks again everyone.

[Migrated content. Thread originally posted on 10 March 2010]

I have the following statements (replaced a few characters in command with * for security) in a program:

INITIALIZE CMD-FLAGS.
COMPUTE CMD-FLAGS = CSYS-SHELL
CSYS-HIDDEN
CSYS-DESKTOP
CSYS-ASYNC.
INITIALIZE DATA-LINK.

STRING "START "
"http://**********.****.net/ReportServer/"
"Pages/******Viewer.aspx?/***** Server Reports/"
"DataDump&rs:Command=Render&PCRID="
DELIMITED BY SIZE
WS-BI-PCR-ID DELIMITED BY " "
INTO DATA-LINK.
CALL "C$SYSTEM" USING DATA-LINK
CMD-FLAGS.

When we look at the data-link variable in debug it has the full correct value in it. The issue comes in when the CALL statement happens. In Internet Explorer when the HTTP address stops at the "&" character. So all we get is everything up to the "DataDump" part of the address and nothing after. This of course is an invalid address so the page does not come up. I have tried to use HEX values for the "&" and that did not help. I have also put "&" in other places in the address and where ever the "&" is the HTTP address ends in IE.

Has anyone ever had issues passing HTTP address like this before?
GOT IT!!!!

After all you guys help and lots of trial and error in a windows command box the followig works....

STRING
"START "
"http://**********.****.net/ReportServer/"
"Pages/******Viewer.aspx?/***** Server Reports/"
"DataDump "
'"' {this is a double quote inside single quotes}
"&rs:Command=Render&PCRID=" DELIMITED BY SIZE
WS-BI-PCR-ID DELIMITED BY " "
'"' {this is a double quote inside single quotes}
DELIMITED BY SIZE
INTO DATA-LINK.

[Migrated content. Thread originally posted on 10 March 2010]

I have the following statements (replaced a few characters in command with * for security) in a program:

INITIALIZE CMD-FLAGS.
COMPUTE CMD-FLAGS = CSYS-SHELL
CSYS-HIDDEN
CSYS-DESKTOP
CSYS-ASYNC.
INITIALIZE DATA-LINK.

STRING "START "
"http://**********.****.net/ReportServer/"
"Pages/******Viewer.aspx?/***** Server Reports/"
"DataDump&rs:Command=Render&PCRID="
DELIMITED BY SIZE
WS-BI-PCR-ID DELIMITED BY " "
INTO DATA-LINK.
CALL "C$SYSTEM" USING DATA-LINK
CMD-FLAGS.

When we look at the data-link variable in debug it has the full correct value in it. The issue comes in when the CALL statement happens. In Internet Explorer when the HTTP address stops at the "&" character. So all we get is everything up to the "DataDump" part of the address and nothing after. This of course is an invalid address so the page does not come up. I have tried to use HEX values for the "&" and that did not help. I have also put "&" in other places in the address and where ever the "&" is the HTTP address ends in IE.

Has anyone ever had issues passing HTTP address like this before?
GOT IT!!!!

After all you guys help and lots of trial and error in a windows command box the followig works....

STRING
"START "
"http://**********.****.net/ReportServer/"
"Pages/******Viewer.aspx?/***** Server Reports/"
"DataDump "
'"' {this is a double quote inside single quotes}
"&rs:Command=Render&PCRID=" DELIMITED BY SIZE
WS-BI-PCR-ID DELIMITED BY " "
'"' {this is a double quote inside single quotes}
DELIMITED BY SIZE
INTO DATA-LINK.

[Migrated content. Thread originally posted on 10 March 2010]

I have the following statements (replaced a few characters in command with * for security) in a program:

INITIALIZE CMD-FLAGS.
COMPUTE CMD-FLAGS = CSYS-SHELL
CSYS-HIDDEN
CSYS-DESKTOP
CSYS-ASYNC.
INITIALIZE DATA-LINK.

STRING "START "
"http://**********.****.net/ReportServer/"
"Pages/******Viewer.aspx?/***** Server Reports/"
"DataDump&rs:Command=Render&PCRID="
DELIMITED BY SIZE
WS-BI-PCR-ID DELIMITED BY " "
INTO DATA-LINK.
CALL "C$SYSTEM" USING DATA-LINK
CMD-FLAGS.

When we look at the data-link variable in debug it has the full correct value in it. The issue comes in when the CALL statement happens. In Internet Explorer when the HTTP address stops at the "&" character. So all we get is everything up to the "DataDump" part of the address and nothing after. This of course is an invalid address so the page does not come up. I have tried to use HEX values for the "&" and that did not help. I have also put "&" in other places in the address and where ever the "&" is the HTTP address ends in IE.

Has anyone ever had issues passing HTTP address like this before?
GOT IT!!!!

After all you guys help and lots of trial and error in a windows command box the followig works....

STRING
"START "
"http://**********.****.net/ReportServer/"
"Pages/******Viewer.aspx?/***** Server Reports/"
"DataDump "
'"' {this is a double quote inside single quotes}
"&rs:Command=Render&PCRID=" DELIMITED BY SIZE
WS-BI-PCR-ID DELIMITED BY " "
'"' {this is a double quote inside single quotes}
DELIMITED BY SIZE
INTO DATA-LINK.