DSXchange

Hi,

My design is MERGE----->SEQUENTIAL FILE.

Iam getting the datasource is empty.

Even on the link i can see 0 rows/sec.

That means its not reading the data from my sequential file.

please help me Gurus .

cheers;
vijay

Hi Gurus, Every thing is working fine. Drag and drop functionality is present. Its not reading the data from my sequential files. Actually my designs are ODBC----->TRANSFORMER----->SEQUENTIAL FILE1 ODBC----->TRANSFORMER------>SEQUENTIAL FILE2 i have dumped the data from odbc into sequential file 1 ,...

Hi Gurus,
How to work around with FTP document, iam not able to access the Help document on FTP which you specified GURU. can anyone help me so that i can show a example to my team lead, how ftp works.

cheers;
vijay

Hi Gurus,
Thanks Very much.

cheers;
saama

HI, One of my friend was asking me that ,where is the job developed in the datastage is saved and in which format it is stored. I explained him that , a folder is assigned by datastage, to each and every project , there datastage job is saved. i couldn't explain him clearly, can anyone help me with ...

Hi Gurus,
I copied and pasted the code as it is, iam getting the output as
IF INDEX(UPCASE(@RECORD),PROJDEF,1)>0 THEN FOUND ELSE.
jobname=salma
category=vijay
object name=xxx
ole type=yyy
It doesn't give desired output, please help me.
cheers;
vijay

Hi Gurus,
I have searched the forum, and analyzed that ,Its because it doesn't bother to maintain the integrity of data, it doesn't search for indexes while processing.am i going in the right way.

cheer;
saama

Hi Gurus,
On what basis OCI STAGE has better performance than ODBC STAGE.

can anyone help me out, only it uses native base connectivity we can't say that it has better performance than ODBC. plz help me out whats the reason behind.

cheers;
saama

Hi Gurus, From the administrator, iam giving the command SELECT DS_JOBS.NAME AS JOB_NAME,DS_JOBS.CATEGORY,DS_JOBOBJECTS.NAME AS OBJECT_NAME,DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS ."IF INDEX(UPCASE(@RECORD), 'PROJDEF' , 1)>0 THEN 'FOUND' ELSE ' ' '' AS FOUND FMT '5L' FROM DS_JOBS,DS_JOBOBJECT...

Hi Gurus, Its working fine , i used command dsjob -paraminfo SALMA10 JOB1 $ODBCCONNECTION. Iam getting default value- $projdef. i went to director and checked the log, i can't find the Actual value. please help me Gurus, from where i can get the actual value. Thanks very much Gurus, please help me h...

hi gurus, can't we view in designer the job which they created.one of my friend said that as we import the job it is stored in saperate category in the designer and thereby i can view the job which i imported. is this is not possible in datastage to view the job in designer, i mean cant i view in de...

Hi gurus,

thanks very much , Actually i analyzed the property incorrectly.

Thanks very much.

cheers;
saama

hi gurus, my design is odbc---->transformer--->odbc. i have i/p column hiredate. its format is 1980-12-17. iam defining column properties as MONTH.TO QUARTER('HIREDATE') will i convert months into quarter, will i able to view the quarters. am i going in the right way.plz gurus help me. cheers; saama

hi gurus,
in the transformer properties , i got tabs only to specify before sub-routine or after sub-routine, how should i call utilityhashlookup.
plz help me gurus in analyzing.

cheers;
vijay

Hi gurus, i cant send to my companys mail id, it simply says SMTP SERVER CONNECTION FAILURE.so i want to send to yahoos or gmails.what would i write the name of SMTP SERVER for google or for yahoo. SMTP SERVER NAME: SENDER EMAIL ID- SSS@GMAIL.COM RECEIVER EMAIL ID-YYY@YAHOO.COM i want to make sure t...