DSXchange

Hi All, When i am compiling the job, i am getting following error. Please help me .. Regerds Krish Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 11:14:17(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.5.0.5796 Copyright (c) 2001, 2005-2008 IBM Corporation. Al...

Hi All, I am trying to configure Information Analyzer in version 8.5 While configuring the Analysis Database (Under Analysis Settings) i am getting the "Error Error Executing DS Job" when i click on Validate Engine Connection Button I have added entries in the ODBC.ini file and those DSN's...

Hi Sura, I have used the following code to connect to sql serve rdatabase ErrorCode = 0 ;* set this to non-zero to stop the stage/job $INCLUDE DSINCLUDE JOBCONTROL.H Call DSLogInfo("STARTD",DSJ.ME) InsertStmt="INSERT INTO DATABASENAME.dbo.T values ('AB');" Call DSLogInfo(InsertSt...

Hi Ray, "DATBASENAME" in my context is actual database name in my SQL Server which is 'GMFIT" In my actual coding i have used this GMFIT, I just modifed to DATABASENAME while posting so that there won't be any confusion. If possible can you let me know the syntax to use ODBC connectio...

Hi Ray, I did check with my DBA, and it seems like its not connecting to Database. None of the activity is triggered after the routine has started running. It seems like its problem with the statement SQLCmd='"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD" -S DATABASENAME -U U...

HI Ray, ErrorCode = 0 ; * set this to non-zero to stop the stage/job $INCLUDE DSINCLUDE JOBCONTROL.H $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $INCLUDE UNIVERSE.INCLUDE ODBC.H $ENDIF *---- Start processing strOutPath = DSGetParamInfo(DSJ.ME, "RP", DSJ.PARAMVALUE) paths=DSGetPara...

Hi ,

I tried to debug the routine, also noticed its not connecting to database.

Is there any command to check if the connection is succesful or not?


Please let me know if i had written the correct code.

In meanwhile i am exploring things from DBA side also to see what went wrong

Hi All,

Any more suggestions are welcome

Hi Chulett, I have give the following code as per your instructions InsertStmt="INSERT INTO DATABASE.SCHEMANAME.TABLENAME values ('" : SequenceName: "');" SQLCmd='C:\Program~1\Microsoft~1\90\Tools\Binn\SQLCMD -S DATABASENAME -U USERNAME -P PASSWORD -q "' : InsertStmt : '&quo...

Hi Chullet, I have added SQLCMD to th epath but still no luck below is the error message QueryOutput'C:\Program' is not recognized as an internal or external command, operable program or batch file. It seems like its consiedring the SPACE after Program Belwo is the syntax for the code i have added C...

Hi Ray, SQLCMD executable file is present the following location on the server at which datbase is installed C:\Program Files\Microsoft SQL Server\90\Tools\Binn\ I modified the code to SQLCmd='C:\Program Files\Microsoft SQL Server\90\Tools\Binn\ -S -S DATABASENAME -U USERNAME -P PWD -q "' : Ins...

Hi All, I need help in connecting to SQL server from datastage after job sub routine I am using the following command in the routine to connect, but couldn't connect SQLCmd='SQLCmd -S DATABASENAME -U USERNAME -P PWD -q "' : InsertStmt : '"' Error message: QueryOutput'SQLCmd' is not recogni...

Hi I am reading data from flat file and i am receving null values in date field from the source. When i am converting data from string to date in sequential file stage, i am getting following error. Data string '#00010#A' does not match format '%yyyy%mm%dd': an integer was expected to match tag %yyy...

It's heppening same to me for some times. When i am restarting services, i am able to see the the jobs in folders.

You can use transformer stage to genetate the sequence.