DSXchange

Output from DSExecute is a dynamic array, so there's more than just your 'line count' there even though you can't see it. You need to remove it before you make your comparison. Try making this change to your routine: Ans = Output<1> -or- Ans = Convert(@FM,"",Output) One of the two ...

waklook wrote:for using the URL / File path option i missed to choose YES for fully qualified option in folder stage, now it's working

Good point and something I'll remember to mention from now on in this regard.

Out of the bajillion messages posted here, yours is the first to mention a 'runtime error 13'. Can you verify that is the exact phrasing? I'd be curious what exactly 'upgrading the Client license' means. Does the error occur for everyone or just you? You might want to reinstall the client software ...

i have tryed the URL/File path but it does't work with me What exactly "doesn't work" about it? the job design is like this: FolderStage --> transformerStage --> XML inputStage --> transformerStage --> 2 SequentialFile + other stuff including pivot stage Remove the first transformer, it can't be pr...

No, you need to filter them out post-pivot via a constraint or some other mechanism.

An 'empty' file can also have a single header record, in which case it will not be zero bytes in size but still process zero rows. My advise was more for the masses, general advice for determining emptiness and not specific to this issue where the OP 'knows' empty does in fact = zero bytes.

Welcome! :D First question would be: does the sort order you've asserted in the stage support the grouping being done? If you have, then rows will be flowing through the sort stage as the job runs when each 'sort break' occurs - and I doubt you would be seeing this problem. Since your issue seems to...

You missed my point. Completely.

Granted, but it's the only alternative that doesn't require an outlay of cash.

Curious, would the DOS sort command be any better? I doubt it, but have nothing to base that opinion on.

Exactly.

Let me rephrase. I could care less what your 'group that has access to the DataStage software' is called, my suggestion was to make it - whatever you name it - your primary group. I used it because the OP did. That's all, no subliminal agenda on forcing a certain group name on the world.

Who, me? Tons.

The resolution seems to be to use shorter queries. That or the ODBC stage.

All MS-DOS commands have help built-in. Open a command prompt in Windows - Start / Run / cmd - and then type the command followed by /?: sort /? SORT [/R] [/+n] [/M kilobytes] [/L locale] [/REC recordbytes] [[drive1:][path1]filename1] [/T [drive2:][path2]] [/O [drive3:][path3]filename3] /+n Specifie...

Nope. You cannot pass parameters via dsjob that do not exist in the job. You can, however, build intelligent job control that has access to a pool of parameter values and queries each job for the parameters it needs and just issues assignments for those.

It always helps to explain what you are doing rather than ask a single targeted question with nothing to give it context. The size of the XML file shouldn't be an issue. I've processed XML files that are hundreds of megabytes in size without issue and without buffering or IPC stages or any other hoo...