DSXchange

Hi !

I want to code in VB calling for SP from another server in MS SQL SErveer .

Thank you

I don't succeed . I try with :

$INCLUDE SYSCOM FILEINFO.INS.IBAS
OPEN '','fff' TO fff
ELSE STOP 'CANT OPEN FILE'
PRINT FILEINFO(fff,FINFO$TYPE)

from help and get error with FILEINFO()

I need the information from DS via routine or somthiing

I juct want to know the size I dont use it . I use Dynamic Hash File

Hi !

Is there way to know hash file size (include its directories created by DS) from DS DEsigner or Manager or Director or Administartor ?

"scripting something to execute the sp "

How to do this ?

My sp Inserts one row into 5 table . Is there is way to call sp within VB code

Thanks a lot

Ok . But how to create Category in Category ... Name SubCategory. The second level in Category Hierarchy

I try to find out if I can to create Category in Category in Designer. I have many jobs and only one level of Categories not enouth for me .

Interesting to know if anybody have the same problem and how you have solved the issue.

Te sp will be invoked from batch . Is there is way to do it from Datastage ?

Hi ! I have question . I have asked it before but havent got reasonable answer. After I run 5 Jobs with Sequencer . I want to Enter each of 5 Tables specific row with with specific key. I wrote sp but "Stored Procedure Stage" have to be with Output or Input Link and I want to run the sp an...

Hi !

MS OLE DB stage I get Error :

JobName..JobStage(Transformer in my case): OutputLink:Array 9 has invalid row(s).

What does it mean ?

Yes . I see in DS that the column defined as Timestamp (Length - 23 , Scale 3) .

I build the Timestamp in format yyyy/mm/dd hh:nn:ss but it still doesnt work. I see that DS doesnt conveert it before entering it to target table as it happens with smalldatetime case

How I can to do cast ?

Hi !

I use datetime type in SQL Server and in DS it defined as timestamp.
When i bring char that I used eirlier for smalldate time I get warning :

results of SQLColAttributes(CustBrthdate) gave MetaData mismatch
COLUMN.TYPE Expected = Timestamp Actual = Char

Any ideas ?