DSXchange

qt_ky wrote:So the file pattern in that case would need to be something like *.txt or *.* ?

This works for sure as i have used in the past.

IBM documentation says like Craig said but no luck when i tried few years ago.

To understand the syntax that the stage is expecting, first select "Auto-generated update & insert" and you can see it. You can copy the auto-generated one and modify as you need. Just add surrogate key column to the column list and add the value as Eric mentioned. How many columns do ...

Record is being rejected or ignored? Do you have a reject link which writes to a sequential file? If yes, that would give more information why the reecord is rejected. Make sure you enable a property within Enterprise stage to get the rejected record. Anyways, do you have an Oracle sequence created ...

You can very well compile the job in DEV environment rather than doing any export/import again.

Anyways, tell us what your routine is doing?

It's time to inform your administrator or open a PMR.

I don't know your easy way but it is possible. Get sysdate and pass it as a parameter to the job that creates the file.... Got to use sequence

But want know how recieve the data as seperate columns from the Code. I answered your question but did not say that it is the best method. Anyways, column export can't be used for your case. It's column import to split one field into multiple. You can also use transfomer stage but you need to decid...

ah.. Should have phrased it differently. ;) Kryt0n, 2000 is evenly divisible by 100 and 400, & so it is a leap year. My other condition is "Not evenly divisible by 100 but evenly divisible by 4". This is applicable for years that are not centenaries.. If none of the above conditions is...

This is not the answer for your question. But it would be great if you locate 'Help' button on the start loop activity That will give you enough information

You can change your JAVA code to return multiple columns as output. I have seen this in at least 1 project.

What about second & third run's output?

Eric, good one.. i was asking about any other mathematical way

Why on friday?

Explain us what you are trying to achieve in english.

got this one from wiki.. may be useful to know.

How to find if a year is a leap or common?

Not evenly divisible by 100 but evenly divisible by 4.
or
Evenly divisible by 100 and evenly divisible by 400.



Any other logic available?

such a non-realistic requirement?