DSXchange

Hi kamesh,
I have one suggestion.First in sequential file stage go to "format " tab ,there on final delimeter give one right click now one window will open there select "unix file termination".
I am not confirm on it.............

Hai ,
First u take two stage variables like stg1,stg2 .logic in stage varibles is

stg1=6-len(dslink.input)
stg2=str('0',stg1):dslink.input

Present i have no datastage ,i am sending this logic without checking ,try the logic if u get any problem send it to me.

hai,
I have installed datastage server 8X in windows machine.I wanna know the concurrent users for datastage in server machine.

hai, i am facing one problem i.e,my source is sequential file .one of my column is in 'date' type it is in "YYMMDD" format.i am inserting this values into oracle table using oracle(database) stage.oracle internal format is 'dd-mon-yyyy'.in oracle stage insert command like insert into a1(da...

source: sequential file surrogate key generator target : dataset I have data in sequential file and i am generating surrogate key and loading the data to the dataset. Today i am loading 100 records and i got a sequence of 1 to 100 using surrogate key generator. Now the issue is that next day when i...

i have worked with call a .sql file from after job routine which is in JOB Properties, General tab. in after job subroutine drop down select ExecDos and next to is is Input value where you can type or call your .sql file which in turns calls a oracle procedure. just a example ExecDos sqlplus -s ora...

Hai every body,
i have written one procedure ,using this procedure i am updating one table only,procedure don't need any input and output, but after one job i have to execute this job.how can i execute this procedure in datastage,can i execute procedure in before sql statement.

Is the "ommit" option in the logon screen is deleted from the Information Server 8.0.1 or it depends upon the option during installation.If it(ommit) is not present then tell me how to skip login screen to view director/adminstrator .

Hi,
The problem is bad installation .try to installation again and while installation check the drive file system type ,,,is in NTFS or not

Try installing one layer at a time - repository followed by domain followed by server. That gives you a much shorter install and rollback and it may reduce the chance of failure. If it failed during ... I have tried with layer by layer installation.But after metadata repository while we installing ...

I got a licence CD for IBM information server while i am installing it for "InfoSvr_FedSvr_v8.0.1_WinSvr2003_EN.zip" i got an error after 39% installation: IBM information Server-Install Shield Wizard Configuring IBM Websphare profile "Installing product licence" I have windows 2...

How are u passing the name of the file? Parameter or hard coded? If it is hard coded then u can use a transformer to create the field and hard code this value in the derivation. Not sure if u have a column generator in the server jobs. if u have it then u can do it over there as well. Same if it is...

Hi All, This topic isn't really regarding an error, but best practice. Is there any magical number of lookups you can do in one transformer before you should use a second tranformer? Is there a performance difference between doing 20 lookups in one transformer and 10 lookups each in 2 transformers ...

Hi, i have faced the same problem and overcomed with one method,i.e. you first take job what u have run infinite time in job activity, next keep that between start and end loop,next in start loop take '1' in from ,take '1' in step and take some large value like '9999999999999999999999999999999999999...

Hi ,
i have one file is
file1.txt
1,2,3
2,3,4

I wanna add the file name in every record like
file1.txt,1,2,3
file1.txt,2,3,4
i have to use dos commands in before job routine.while reading this file i need to get with file name

thkssssssssssssss