DSXchange

forgot to release the multiload seeiosn

Hi All, I am getting the following error message in my Report File: UTY0832 This MultiLoad import task cannot proceed: an unexpected MultiLoad phase, data acquisition, was reported by the RDBMS. JOb Description: Inserting a sequential file data to teradata Using Teradata Multiload? Any idea what it ...

Thanks Raj..

Sorry to ask again... Any tentative date Yet when it would be posted?
Thanks heaps
Reddy

Hi sreedhar,
How do we do it manually can we hardcode the header and how do we do about counting the records and appending at the end in the trailer.
Thanks
Vee Yes

HI All,
Thanks for your reply...
I am pulling data from Oracle and Dropping on a sequential file....
In normal scenario we would only have the data with Only the Detail records, Our requirement is to add a Header and Trailer to count the no of records in the file.
Thanks
Vee Yes

HI Everyone, Before posting this topic i did searched for my requirement without any luck. can anyone help me how to create a Sequential file with a Header and Trailer(Count) in a sequential file? My requirement would be Header(This is a Test File) Record 1 Record 2 Trailer 2 where Trailer 2 is the ...

Typo It should have been enterprise stage rather than Oracle_OCI

Normally I guess in all dev environments Oracle will be on One node, But in Production there is every chance it is on mor ethan one node or RAC Cluster, This was the only deifference for us from DEV to PROD so when i included that ENvironment varaible at the project level it worked for all parallel ...

I Posted the above problem because i could not find the correct solution: JOhn from IBM has helped me solve the probelm: Many Thanks Jhon... Please find the solution Below in his words: If you have an Oracle cluster environment (RAC) the checking for Oracle Parallel Server (OPS) will fail in this ma...

When i migrate my Jobs from Dev environment to Production i get the follwoing error message: Oracle_Enterprise_0: APT_OraInstanceSet::setup() failed to find an Oracle instance on node node1; the hostname is `XXXXXXX'. My Server jobs works fine but having problem with the Parallel jobs: JOb Desc: Pul...

Good Day All, I am running a Parallel Job picking up a Sequential file from Datastage unix Box and dropping it on Teradata. One of my column datatype is Varchar accepting null values, when i run the job using Teradata Multiload, Null values for that particular column are showing as '000' insted of n...