DSXchange

Arent all the libraries are compiled and stored in the path where the routine is called? If not arent the path been included in the LIB path?

It shows that you data is not joined based on the given key columns. Not sure if you are the one who created the other post for unsucessfull join in Join stage. There are factors like, Sorting order, Partition, data type.... Pls do a search. If you feel that you have mentioned all parameters correct...

The version I use currently is 7.0, and it doesnt have this extra functionality of compiling. And it not mentioned in document as well.
In you scenario, why can developers export or promote the compiled code?

Were the data been joined based on the key? what is the job desing? What is the stage right after Join stage? Is it 0 or blank?

What is the user (role) that been used?
Its interesting that
o Compile server and parallel jobs
o Generate code for mainframe jobs
are not included in the help text, though Compile wont really affect the design, unless a change in canvase otherwise.

Hi Jan,
Truncating the Child table while parent table data are still populated, will cause the Foriegn key Cascade constraint error. Make sure you truncating the Parent table first and then the child table.

:? I don't see how that would help. The OP stated that it failed occassionally, not constantly. Lack of that JOBCONTROL header file would cause something that needed it to not even run. Its a good point to consider. For testing purpose, change the routing to ExecSH and use dsjob --linkinfo with the...

Iam sorry I dont know where I got this from .
You should be looking at the format of the data type of that field with the other method.

Try mentioning the extension of micro seconds in the datatype of that field using field properties.
Converting seconds into micro second is by multiplying by 1000000 and adding with the microsecond part of the exisiting values. Converting minute into micro second would be 60*1000000 and so on...

One approach would be, count the number of records (can be using link row count) and pass it as a variable into Loop activity, for each loop read the corresponding line of the file and pass the value as parameter to a job to create a file using that job parameter value.

Suggestion - The C++ code that you have written, can be made to give output corresponding to the given input so that the database can be handled in datastage with the available stages. You can post your requirement, so that, alternate methods can be discussed to get max out of datastage functionalit...

Use column generator on both the inputs and join on the temp column whose values is 1.

You dont need to concatenate with ":" and then mention the format as %HH:%MI... You can straight away give %hh%nn%ss.xxxxx. The other method is convert all hh, nn, ss that you found using svToCharAccessID)[7,2]:":":(svToCharAccessID)[9,2],Sad(svToCharAccessID)[11,2],(svToCharAccessID)[13,6] to micro...

What is the Transaction size that you have set in the OCI stage? If nothing is given, give some value. Have you tried resetting the job to find "From previous log..." error message? Have you tried disabling the combination of operator? Is this topic resolved with workaround? If not you can delete th...

Hi Swetha,

Welcome to DSXchange :D !!!
In latest version, Integration server, you can surface Datastage through webservice. And quality stage can be invoked as a stage in Datastage. And hence you can accomplish you task. But you can expect some one to update you on the existing versions.