.html file creation

synsog · Post by **synsog** » Wed Apr 04, 2012 9:31 am

Hello,

I was trying to create a .html file in datastage. Structure of the file contains two columns. When i generate the file in .html and move the file from Unix to windows i was not able to get the output in a tabular form. Its coming as a line. Please can anybody help me on this. Thanks in advance.....

jwiles · Post by **jwiles** » Wed Apr 04, 2012 9:37 am

Are you meaning in an html table so that it appears correctly within a web browser? If so, then you need to make sure that you include properly-formatted HTML language elements in your file so that it is properly viewed in a tabular format within a browser.

If you don't know HTML, you can search in Google for online references and training.

Regards,

synsog · Post by **synsog** » Wed Apr 04, 2012 10:49 am

So u meant to say i can use HTML coding in datastage..? Sorry i didnt understand can you please shed some light on this.....

jwiles · Post by **jwiles** » Wed Apr 04, 2012 11:31 am

No, U (one of the forum members) did not say anything in this thread. The proper spelling to use is 'you', not u. We're not texting here...

DataStage does not directly support HTML file creation. You will need to manually generate the proper HTML language elements (containing your data) to meet the requirements you have so far described: 2 columns in a tabular format. HOW you create those elements is up to you.

1) You could create them within a transformer
2) You could create an external script/program which creates all that for you and places your data into the proper HTML elements

Question 1: Does your html file need to include all of the standard HTML elements of a web page, does it simply need to contain an HTML table definition with your data, or do you simply need to name the file with the .html extension? Do your business rules (job specifications) state which it is? If not, you should ask for clarification.

Question 2: If the file needs to contain proper HTML formatting, do you know/understand the HTML language? If not, you should educate yourself or find someone on your team that does for assistance.

Question 3: What does your output file currently look like?

Regards,

ray.wurlod · Post by **ray.wurlod** » Wed Apr 04, 2012 3:21 pm

You might also consider changing the Sequential File stage to use DOS style record delimiter string.

chulett · Post by **chulett** » Wed Apr 04, 2012 4:12 pm

We want to make sure you understand that simply writing to a file with an extension of ".html" does not get you an HTML file, there's more to it than that. And with no such thing as an HTML Output stage, you have to do all of the heavy lifting yourself inside the job.