DSXchange

And this flat file is transformed and loaded to a DB2 Database (target)

Hello All: I am getting a VSAM file (Binary) converted to ASCII format as my source file. This source file is a flat file with fixed width length. However there are many columns as type "Fixed Decimal". When I see the data of these fixed decimal columns I see weird characters. How do I do ...

Thank you much kduke........MJ

Hi Ray and kduke:

I cannot access the routine when I click on that link... it gives the following message:

"The topic or post you requested does not exist "

kduke, would appreciate if you could re-post that routine again.

Thank you much in advance.

MJ

the Link:

The link is viewtopic.php?t=85791 .

ray.wurlod wrote:There was a routine posted some time ago for dumping a table definition in CSV, XML or IMF format. Search for it. (IMF format is used by QualityStage.)

Hi Ray:

There was a link but it say that that topic is no longer avaliable hence unable to download your code.

MJ

You can export the table definitions (from the manager -> Export -> DataStage Components and then choose table definitions) into an XML formatted file, an excerpt of the output look like: <Property Name="Name">IDIATCTY</Property> <Property Name="Description" PreFormatted="1...

Hello: Is there a way to save the table definitions used in Datastage Server 7.5 to a word or text format....? When I generate a report using Datastage I am able to get the input or source colums saved as text files ....however the output files are not so straight forward.....(go figure...) some of ...

Hello kduke: Thank you very much. Appreciate it..... :D What a relief that my jobs will not loose its code if I have imported fresh MetaData into Table definitions. As for the other issue I will go and look at your routine as well as Rays. Yes the reporting tool in DataStage does give the metadata a...

Hello: Hi, You mentioned that jobs fail. Q. What error do you get? Ketfos No I did not mention that the job failed. Rather would like to know if I delete the table definitions and import the new and modified ones and leave the jobs as it is and if ran the jobs would the jobs fail. The jobs will not ...

Hello: Is there a way to output all "server" job's "Output sequential file's tables" into one file ...? Another Q, in the server jobs: In Erwin the tables were modified (columns added, removed, type/length changed). In Server the columns were modifed manually per job wise. (i.e. ...

Hi chulett:

Thanks a bunch.

Mamta

Hello All: I have various Batch jobs based on Date in Version Control. They are all in version 1.0 jobs in version control. When I import the jobs from Version Control to DataStage Server as of that Batch Date I have the following issues: 1. During selection of the job to import there are 4 jobs of ...

Hello All: I think I have the solution to this problem. The issue was not link collector or version issue with 7.5 but the meta data and the linking from shared container to the link Partitioner/Collector. I deleted the shared containers, relinked and validated the links to other stages, verified th...

Hello: Read on some of the searches for the same kind of error. And I have set the Inter process buffer in the job. Although, the meta data differs in the sense that source file has 2 extra columns. Only in the shared container's transformer do I not pass the 2 extra columns to output file. So in tr...