DSXchange

Sainath.Srinivasan wrote:dsEdi,

What is the issue you are facing?

Hi Sainath,
Welcome back, after a long break. :D

The moral will be more interesting for the Support team working for Datastge.

Database like DB2 / Oracle has the option to specify "Silently Drop the unavailable column". Enabling this, should help to avoid the errors poping up when source fields are not available in Target tables.

DSguru2B wrote:Unload your table into a flat file or dataset and then do your transformations and loading.

But it again require two jobs, or some superfluous flow isolating stages.

As noted by Ray, you can go ahead and clear the files avialble in TEMP dir or Scratch disk when the jobs are not running. Those are temporay files used by intermediate stages available in the jobs like SORT, Aggregator etc.,
It can be isolated to different node pool via Config file.

DSguru2B wrote:Hmm, interesting. Server is still linient. Even if these functions are not used, the datatypes can be altered by specifying different target datatypes.

Yes for most of the cases.

The workaround given by Ray is to help you to construct the Schema file easily. But to get the actual solution, you need to specify what is the exact requirement of yours.

Its all depend on how you construct your container. It will be easy for this kind of scenario to construct the job and later club the stages and convert it into Containers. The containers should have one input link and two output links. Make sure the metadata exactly match the Containers to the Job's.

The main function of the Iconv is to convert the external data type into Datastage internal format, and Oconv is to convert the Datastge internals to External format. String to data or vice versa, or Decimal and its vice versa etc, are done using this.

You can have Order by / Having in 'Others' option in SQL builder.

But 7.5.1 will over ride the 7 installation. Do you mean at different location?

If its all about, Server job, why in PX forum.

There are 'Conversion' available under 'Functions'. Iconv/Oconv are majorly used.

Hi Uma, Welcome Aboard :D !!!! Though your post is not clear, I assume, your intention is to convert PX job to Server jobs. But why? If you intend to convert, obviously it will be less no of stages. Because, the available no of stages is very less. And most of the functionality is aceieved through T...

DSguru2B is right. '%' is working, contradictorily '*' is not working.