DSXchange

Hi All, I am trying to pass the data from one table to another table. I took oracle enterprise stage i can import the metadata from the database when i try to view data it says missing server. Properites have been setted by giving Table name, User and Password.., I cannot see any property which ask ...

Hi,

Designed a job as

Sequential file stage--------------->Sequential file stage
just passing data from one file to another file facing an error as below stated

main_program: Fatal Error: Null archive.

please help me to resolve the issue

Thanx in Advance

Hi,

That is meant to be sequential file stage

Thanx

Hi I am trying to read data from the file and load into a table. the job designed as FileStage---CopyStage----OracleStage Filename---->given the file location Setted the property for file format as delimited now when i try to preview the data in the file stage the error which i pasted is throw thanx

Hi, Developed a small job with using file stage the job got compiled but unable to preview the data nor after running the job it is throwing the below error. ##I TFCN 000001 17:42:59(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Software C...

Hi

please list me some of the differences between the dataset and a fileset

Thanx in Advance

[quote="ray.wurlod"]Set up a stage variable (type VarChar(8)) to contain the trimmed string.
Construct the output string with sufficient leading spaces (1-Len(svTrimmedString)) then the trimmed string. ...[/quote]


Can you please explain in steps that would be great

Hi,

I had a sequential file which is getting the data as string(8) for Ex: 12345 that means 5 char and 3 spaces in need to shift these spaces to left i want the output as 12345 (i.e) 3 spaces and 5 char

any functions are thier please let me know

Please help me on this

Hi,

Iam building a stage by stage type and build i need to hardcode a parameter for one column which is passed through job parameters in transformer i can pass it by hardcoding in the column derivation cell. please help me out in coding how to pass parameter in build op stage

Thanks
Raj

hi

can anyone help me in writing a shell script to schedule a datastage job

regards
roger