DSXchange

IN oracle it is set to 'AMERICAN' . Since I have don;t have admin right in datastage, I am not able to view it. But it must be different then in oracle, as I am getting this behaviour

Hello All,

I want to catch the user defined exceptions in a PL-SQL procedure and display them on Director logs, I am using a Stored procedure stage to trigger the PL-SQL code. Can this be done in datastage? Need help in this regards.

Thanks
Gokul

Hi All, I have a follwing job design OraTable -------->Transformer-------->OraTable a> The source & Target are Oracle Enterprise Stages. b> There are 2 targets, one for good records and other reject table where we will have bad records. In the reject table , I want to capture the oracle error co...

We are in process of generating XML output file. <B>Process:</B> a. We have 4 sequential source files containing data to be merged into a single XML file. b. The Header for the XML file contains which comes from the 5th sequential file. The Header also contains some other information like Message an...

Hi All, I have created a Distributed Hashed Files EMPLOYEESALL with part files as EmployeesATOL ,EmployeesMTOV and EmployeesWTOZ. Data is loaded in the hashed file EMPLOYEESALL. But when i use hashed file EMPLOYEESALL as a lookup with Pre-Load file to memory enabled or Enabled,Lock for Updates ,it g...

Hi Following are the queries related to the Sequential Stage which popped up during the debugging of a code 1.During debugging a code,we realised that the number specified in the Display column was large then the number specified in the length column of the data grid of the Sequential Stage. Due to ...

Hi Ray,

Since the question was

if I have single column source that have 0,1,..N rows -- how can I transform into single line? ie:

source
AAA
BBB
CCC

output: AAA BBB CCC

I have consider a single source column. As always we hope to get a generic solution from you.

Gokul

what type is the source is it? 1> If the source is Oracle then u can try the below query as user defined query and get the required result. select max(decode(rownum,1,dname))||max(decode(rownum,2,dname))||max(decode(rownum,3,dname)) C from dept 2> If the source is sequential and u r writing in a seq...

Thanks Craig,

I tried with the Transformer stage in between, it worked.
After that i recreated the job again without the transformer, it ran succesfully.

i may missed some step during my first attempt.

Thanks again,

Gokul

The More Buttons Says
(TestHash.Hashed_File_1.IDENT1)

Since the Hashed file is not created , i cannot view it.
The error i got was during compile time and hence hashed file is not created.

Hash file contains 2 columns Col1 and Col2 . Col1 is the key column.


GOkul

Hi , I have created the static type 3 hashed file using command line of adminstrator. I am trying to create the hashed file through the datastage job. I have specified Type 3 in the Create file options of the target hashed file. No transformer is used in the Job . The hashed file is created from the...

Hi, In the Delete statement given in the supporting PDF DELETE [file.variable,] record.ID [ON ERROR statements] [LOCKED statements] [THEN statements] [ELSE statements]. What is record.ID? I tried with a file abc.txt containing one record having value "Hello". The Delete statement used to d...

Hi,

In Datastage Administartor ,we can assign roles to the User for a specific user. Where and How can we create the Users of Datastage?
Note: This is not an interview question, i just stumbled across the question.

Thanks,
Gokul

Thanks ArndW,

The UVFIXFILE does not work for 64 bit file,from that we can conclude that RESIZE has worked successfully.

ArndW,

The actual hash file size hash not changed before and after executing of RESIZE Command.

My query is how will determine (without actual loading > 2GB of data in the hash file) that Hash file can accomodate data > 2GB.
i.e execution of RESIZE command was sucessful.

Thanks
Gokul