DSXchange

Hi,

Is the Wave generator which is now available in v8.x possibly also availalbe for DS 7.5.3 ?

It is the same case, even if the database lookups are removed, and the design is -

MQ---->XMLInput------>Trx -------->MQ.

When the Trasnformer is removed, the messages are being written to the output queue. But when it is placed, the job doesnt write anything.

Thanks!

Hi, Have been trying my hands on building an always-on-job using the MQ stages. When a transformer is placed between the Xml input stage and the final MQ stage, the job doesnt write to the queue, in the always on mode. If the properties in the MQ stage is changed to make the job run for a specific t...

There would be other fatal errors also in log, please post them. The given error message does not tell much about the job or the issue at hand. It might not have anything to do with the XML stage. Alternately, run the job with the APT_DISABLE_COMBINATION environment variable to TRUE and then see the...

You might want to check out the OSH generated for the job to see if the SQL query is being taken in completely.

I did face this problem sometime back... A query of length greater than 1020 (or so) was not getting executed through DS, through the query was being successfully parsed to the job. But when the length of the query was reduced by a few characters it ran absolutely fine. Got around this by splitting ...

The error tells that '/home/diff_src.ds' is not a DataSet. Make sure that its not a file - (if its a file use the Sequential File Stage). How was diff_src.ds created? DataSets are different from files. Go through the chapter on DataSets in the Parallel Job Developer's Guide for more information. Or ...

Join_Left_Outer.DSLink20_Sort: When checking operator: Operator of type "APT_TSortOperator": will partition despite the preserve-partitioning flag on the data set on input port 0. This warning tells you that the Sort (TSort operator) on the input link on the Join stage will repartition th...

Can any one help me,how to create an XML file in Datastage. There is an XML PACK (its a plug-in) - and should be available with the default installation. This PACK contains 3 stages - that help you deal with XML data. XML Input stage - used to read hierarchial XML data in tabular or relational form...

2. in runjobtfn under parameterlistparm pass the value "inftctgtfiledate=": JobParametersDefinition.inftctgtfiledate What's runjobtfn ? Seeing the "parameterlistparm" - I think this is a custom routine being used at your site? JoshGeorge's post is clear enough i believe - to get...

You can always read it with a higher configuration - just make sure that the configuration includes the same nodes that created the DataSets. The point here is that a data file (containing the actual data that is loaded in the DataSet) is created on each node defined in the configuration file used t...

You can just type in the DSNs and check it out.

Design 4 Transformer Stage => Sort Stage = Aggregator Stage Sort Stage set to Sequential and remove duplicates. Count correct. Thanks Why not just Hash partition the data to the Sort stage instead of setting the stage to a sequential mode? Set the Aggregator Method to Sort instead of Hash - and thi...

I am having source data format as yyyymmdd which is of integer type(Eg:20070728).I have to convert it in to Date format and load in Oracle table.The column is "date" type in Oracle. Date datatype in Oracle is "TimeStamp" for DataStage.So you would have to convert your input inte...

Are you doing any aliasing in the SQL query on the field throwing the warning?