DSXchange

Hi All I created a Datastage Sequence Job. The aim of this job is to get the list of job names from a file and trigger the jobs it using loop activity stage unconditional. Job Design: Execute Command Activity --> StartLoop -->Job Activity -->EndLoop. Notes: Job Activity will trigger a server job; co...

Thanks Ray

I will close the file. But is it the only way to find the file? Any other command is there to check?

Regards
DS User

Hi All Need: I need to know whether a file is exist in a specific dir. If exist i need to create a .ok file. Is there is any way to do or Can try to open the file like below and if the below command is suceed, then i can create a .ok file. SeqFiles = File Path OpenSeq SeqFiles: aFileName TO Jname Pl...

Hi Ray

It may be NULL and not "NULL". The reason is; It is the retrun value of the Stored procedure (170|NULL|NULL|1).

Thanks
DS User

Hi Ray / craig Apoligies for marked it as resolved. Now i am getting the value concatenate with NULL and i fails to notice it in time. 170|9999-12-31NULL|NULL|1 A = Field ( out, ' ', 1) B = Field( out, ' ', 2) C = Field ( out, ' ', 3) D = Field ( out, ' ', 4) Rtn = Trim (A) : '|' : Ereplace(Trim (B)...

Hi Ray / craig

I tried with Ereplace and it is working fine.

Thanks for your time and guidance,

DS User

Hi Ray Thanks for your reply. As per the logic, sometime it may return NULL value for DATETIME column from the Stored Procedure. In that case, can i able to use NullToValue (field(GetIDs.$ReturnValue, '|' ,2) ,'9999-12-31') ? - (I will try to use like this) Or the procedure need to return the value ...

Hi I am getting a return value from a Server Routine as 170|NULL|NULL|1 170 - INT NULL - DATETIME NULL - DATETIME 1 - INT I am going to use these values as a PARAMETER to load into SQL Server. In the job activity stage i used the below code and getting error "Error calling DSSetParam(ST_DATE), ...

Hi All Issue resolved. The way how i passed the value into the sqlcmd is the problem and found it. The below code is working fine. 'sqlcmd -S ServerName -U UserName -P Password -d DBName -Q "SET NOCOUNT ON DECLARE @ID INT EXECUTE dbo.ProcedureName InputValue, @ID OUTPUT SELECT @ID"' In the...

boppanakrishna wrote:Hi All,

Any more suggestions are welcome

Hi Friend

Right now i started to work with SQL Server, The reason for hanging is -q. Take that and replace with -Q.

simple

DS USER

Hi All I written a Server Routine to execute a SQL Stored procedure and it is working fine, but when i execute the same routine using Routine Activity, getting problem. Herewith the Routine code: SQLSTMT = 'sqlcmd -S' :SERVER:' -U ':UNAME:' -P ':PWD:' -d R_Ctrl' : ' -Q ':SQLFILE:' -h -1 -m 1 -W' cal...

Hi All

Found the result for this issue.

SQL Server 2008 R2 is not a supported version for 8.1 Information Server.

Confirmed with IBM.

Regards
DS User

Hi All I had a chance to look into Datastage job issue. ISSUE: Job is simply hanging. (Some day this job will not give any issue) Job Design: Seq file --> TFM --> SQL Server Enterprise stage (Append mode). When i ran the job it is simply in running status in Datastage. In SQL Server the query went t...

I understood the query is suspended as per the log in Database. But no one did it and it happened for some reasons I guess. I will investigate in detail and update the status.

Thanks
DS_User

Datastage job hangs after main_program: orchgeneral: loaded; A simple Datastage job: Read the data from SQL server and write (Truncate and insert) into SQL server. SQL Server Enterprise Stage --> Transformer --> SQL Server Enterprise Stage is the job design. It is running for more than 24 hrs and no...