DSXchange

Guys, Executing the .bat I am developing, everytime that a job is exported a DataStage window open asking me to click 'Close'. If I have 100 jobs, it will ask me 100 times. It says: "x read-only objects were ommited" Is there any way to ommit this window? Otherwise the .bat makes no sense....

The command bellow doesnt work. %DsSearch% -server %Host% -user %User% -password %PW% -ljobs -matches -sub -c %folder% %project% >> %JobList% If a cut the part: " -matches -sub -c %folder% " it works fine. It says: "Valid primary command options are: -ljobs Status code = -9999 DSJE_DS...

Ok. And how do I do?

I derivated the text field like:

NOM_DEV (Char 70 | Unicode | NotNull)

If Isnull(Lnk_Ler_Contratos.NOM_DEV) Then
Str(' ',70)
Else
Left(Lnk_Ler_Contratos.NOM_DEV:Str(' ',70),70)

The NLS map is the project default: ISO-8859-1
And about your first question "How is the file encoded?", what do you mean?
I didnt get it.


Best regards,

Nope .... I didnt set this option.

Yeap, but it is according to your tips. The file input columns are like: COD_MDL_ORG ........ char(4) nullable yes TPO_RPT ................. char(1) nullable yes Edit Row: * COD_MDL_ORG String Type : Field Width = 4 Nullable / Null Field Value = "" * TPO_RPT String Type : Field Width = 1 N...

I tried but it didnt work.
And then I tested with only one char field, the same warning happened.
I can't realize what it could be.

Best regards.

Thank you Chullet!
I used shell script to specify the file names.
It worked perfectly.

Thank you guys for your help.

Best regards,

Sorry guys ask you if I was clear cause my English is so bad. Obviously I couldnt split the xml file after it was compressed. In short, I just wanna know if there is a way I could split it before or after generate it. Forget the compression for now. This limitatiom of 50Mb I could set a limit of row...

Hmmm ... actually the job design is like: DB2 => Transformer => XMLOutputPX .............................. => XMLOutputPX These 2 'XMLOutputPX ' are about the same file, have the same name, but the first one generates the Header, and the other one generates the content. This functionality you meant ...

Chulett,

Thank you for your answer.

When u say "the Trigger Column functionality", what are you talking about?!

Ah, ok. Actually the splited files need to have a correct sintaxe, of course, respecting the open and closed tags. I cant split the big one without care if for example the Open tag is in the first file and the rest of the register is at the second file. I'll have to pay attention to the sintaxe and ...

Imagine guys I have a really big Xml file. A huge one. After zip it and realize that it has more then 50Mb compressed, I have to split the file in files with 50Mb each one, but compressed. The thing is that I will return these files to the customer and he wants a sequential inside the parts, like an...

Hi!
Did u mean an utility from Operation system for example?
Like in a script shell on unix?