DSXchange

Biggest problem I see is there's no Field() function in your code. :wink: To use Field to extract "X Y" from a space delimited string, you'll need to pull two fields, not one... and you would need to know what field number to start with, not the position of the sub-string in the string. Pe...

Are the quotes being stripped when using a job parameter? If so, have you tried escaping them?

tanaya.deshpande@tieto.co wrote:Is there any activity to forcefully stop the sequence

Terminator.

But now if I have more than 1 job activity and I want to run the loop when any of the activity fails then how to do it ??? You certain you want to do that - rerun all of them if any one of them fails? If so, seems to me it would be custom triggers checking all results and deciding where to go, out ...

2) and 3) are not 'enter loop', it is continue loop as you only enter it once... and yes, the counter / iteration will automatically increment each time you take another lap around the loop.

If you have no experience with PL/SQL you'll need to enlist the aid of someone there that does.

Sounds like the metadata you used in the CFF stage is wrong, you need to triple-check it against a hard look at the source file.

There really isn't much to check, as stated all it says is for some unknown reason it lost connection to the database while the job was running. One time, I wouldn't worry about it. If it persists, take the message to your DBAs and probably even Network guys, see if they can help.

Seems to be inappropriately named. Is that the complete file?

srinivas.nettalam wrote:I am not convinced that it can be read parallel and I assume there would be lot of discrepencies in generating the sequence numbers in this scenario. Am I right?

Short answer? Nope.

What does your target SQL look like for that field? Sure you didn't mean "HH24" for the hour?

Define 'everything'... and what exactly would this job be doing? Simply moving data unchanged from source to target? Have you looked into the use of RCP and schema files?

Yes, you do. From what I understand it is still a manual process behind the scenes.

No, it would be a much better learning experience if you manage this on your own... with some guidance, of course.

First order of business would be to capture or store the information you need to send, say like a flat file or the USERSTATUS area of a job. Have you done that?

abhilashnair wrote:Array Size specified in Target is 2000.

As a test, lower it - even dropping it down to 1 to see if that makes any difference.