DSXchange

Hello Forum, I have a job that is simply generating rows and loading them to Teradata via Teradata Enterprise Stage. The Director status panel reports "Finished", and the last log entries report the following "main_program: Step execution finished with status = OK." "Paralle...

Hello Forum,

I have been using Multiloader for situations where I require upserts, which I have unable to do in Enterprise stage. Is there any other advantage to using Multiloader Stager over the Enterprise Stage?

Thanks,

Greg

Hello Forum, What are the different factors that affect startup time. Trivial jobs that I create that have one input and one output file and one transform usually have a startup time of less than 5 seconds. However, trivial read of a table often results in startup times between 15-30 seconds. Is thi...

Hello Forum, My client will be processing some XML files as part of batch processes. They have no need for real time processing or web services or messaging functionality. It would seem that both TX and SOA extensions have XML parsing/transformation features. 1. If my goal is only to process XML fil...

Thanks ArndW.

It interesting that Char seems to be the only conversion function that is available in PX jobs, but is not documented in the Parallel Job Developer's Guide.

Hello Forum, I wish to know if is possible to reference Octal and Hex byte codes in string literals? For example: if (In.StrFld = '\000\001') This doesn't seem to work, as Len('\000\001') returns 8 rather than 2. The documentation does often use \DDD and \xDD notation but not in the context of strin...

Thanks for your response vmcburney. DataStage EE and Server are mainly used to handle relational data. If they have a complex data source such as a complex flat file or XML they usually have to convert it to flat relational records in order to transform them. TX is better with complex data such as E...

Hello Forum, I have no experience with TX, but based on comparisons given here between PX and TX, it looks as though they are competing products with significant overlap. Doesn't the RTI/Soa extension to PX offer similar messaging capabilities to TX? I hear that it can handle complicated datatypes. ...

Hello Ray, You are correct about being a red herring. I still received this error after specifying multiple instances, but received it much less frequently. I tried running the Basic Transformer in sequential mode, and it has not occured (yet). I will try out your suggestions with SPINTRIES and SPIN...

Enabling multiple instances seems to have eliminated this problem. Not certain why. Couldn't find any documentation that mentioned that running Basic Transformer in parallel requires this setting.

I do know that I don't have multiple executions of the job occuring at the same time.

Hello Forum, I am executing a Parallel job containing a Basic Transformer. The transformer has an input from a funnel and 4 outputs (3 seq and one teradata enterprise stage). Basic Transformer is operating in parallel mode with a Don't Combine setting. Job runs fine 80% of the time. The other 20% of...

I want to certain a certain range of bytes against a string constanst. For Example, if (link1.rawfld[1,6] = "String") then parse rest of raw field I wish to declare this field as raw because I want to use the ebcdic attribute on the schema, to allow string comparisons to automatically trea...

Hello Forum,

Is there any method of checking raw values or selecting a substring from them without first using the modify stage to change the column definition?

Thanks,

Greg

I believe them to be all well formed, and all references have # # around them. All options where set with 'Insert Job Parameter' option to prevent typos. The only exception was the following setting: user=#$TDUserId1#,password='#$TDPwd1#',RequestedSessions=4 This one was partially generated by DS an...

Hello Forum, I get the following Error messages while attempting to view data from client in the Teradata Enterprise stage: #E TCOS 000005 09:55:01(004) <main_program> Invalid identifier: $ >##E TCOS 000048 09:55:01(005) <main_program> Parameter not resolvable: ##W TCOS 000049 09:55:01(017) <main_pr...