DSXchange

Jonathan,

Any results? Has this been resolved?

Regards,

We will be getting a records of say length 20. In this record, one field(or one column) will be of type packed decimal and the starting position and the ending position of this field's going to be variable. This leads to further questions: 1) Within a file, are the records all of the same layout? N...

Disable C++ compiler optimization...it's likely affecting the compilation of the transformer because of the large number of columns defined in theinput and output links. For gcc, use -O0 in the compile options, either in the stage itself or at the project level in DS Administrator. I believe it's th...

Hi All, We have a requirement in our project, wherein we need to read a variable length packed decimal field from a mainframe file , which is FTPed into our Unix box. Any ideas on how this could be read? Is the width of the packed decimal column going to change from record to record within a single...

You can't do this the way you are currently envisioning for two main reasons: 1) You can't change job parameters on the fly while the job is running (they are resolved at job submission time only) 2) SeqFile doesn't support closing and opening multiple files during a job run. As the number of files/...

This problem encountered after we upgrade our exchange server. Is there any idea please??? SMTPMail RCV: 550 5.7.1 Unable to relay SMTPMail Not sent to recipient xxx@g.xxx.com.sg I would expect first that the security configuration of the upgraded Exchange server is more restrictive than before the...

It is located in the Columns grid of the Output link of the stage. Output->Columns->Extended column Alternately, you can double-click on the column number (to the left of the column name) to open the properties for that column. There is an Extended (unsigned) checkbox on the left of the window. Rega...

Is there anything called as indirect file reading in DataStage? Meaning, all the files to be read will be put in one file and DataStage should read this file to get the file names and in turn read the files. You could use a FileSet stage. Create a fileset file ( name .fs) containing rows which look...

Hi I would like to know how this can be done dynamically without the help of manual intervention. Schema file is received which is very often changed and this should be handled in Datastage Job. Currently i have created a schema file to read the sequential file but in future if there is any change ...

With that said, I don't think Information Server cares as long as the version of DataStage on both boxes is identical. However, your HA software package (which monitors system "heartbeats" and does the failover if required) might require the O/S to be identical - you'd need to check with ...

Yeah...it caught me off guard. The IS Balanced Optimization documentation has been incorporated into the IS Information Center. Since there's some overlap like that, you've got to make certain which portion of the InfoCenter you're looking at

Hi I would like to know if the file is created by SQL or a Simple Text File which contains the metadata information. Thanks Naveen An Orchestrate Schema definition is a simple text file, the format of which is documented in the Parallel Job Developer's Guide (Appendix A, I believe). The DataStage D...

Looks like IBM has not documented/published the migration path from Version 8.0.1 and later to Version 8.5 ... For more information about migrating your existing DataStage installation or InfoSphere Information Server installation to InfoSphere Information Server, Version 8.5, please send an email ...

Hi, How to convert a Schema dynamically into a Datastage Parallel Schema File Format. Thanks Naveen What type of schema is it--that is, what created it, what format is it in, etc.? For what purpose? Any example you can show? The point here: It's impossible to accurately answer the question without ...

Rumu, The documentation you were pointed to is specific to the InfoSphere Balanced Optimization Tool only and not to DataStage in general. Unless you are using the Balanced Optimization tool, ignore that bit of advice as it's not relevant to your situation. As has been stated in this thread, there i...