DSXchange

I have a simple DS job and I am trying to run it from the command line using DS job as below but it is not running. Both client and server are installed on the same machine on which I am trying to run. Please advise. Command used: D:\IBM\InformationServer\Server\DSEngine\bin>dsjob -run -jobstatus pr...

Does anybody have experience running the Cognos TI process from Datastage and how to do it? I know there is a Cognos TM1 Connector in Datastage. As per my analysis, that is only used for reading and writing the data from/to Cognos TM1 Cubes/Dimensions/Views. Please let me know if my understanding is...

I am passing parameters to a Job activity in the sequence. I have two parameters current month (YYYYMM format) and previous month (YYYYMM) format. Is there a way to derive previous month from the current month (preferably in the Value Expression section of the Job Activity)?

Please suggest.

I am in the same boat. In my case, most of the data manager jobs have transformation logic in source SQL itself. As per my research, there is no way to convert the SQL into datastage jobs using stages. Hence I am developing datastage jobs by copying the SQLs to ODBC connector stage with User-defined...

Are you using Specific file or File pattern option in Seq stage?

Than you all for the responses.

I figured out that I was using Write mode as 'Insert' instead of User-defined SQL. Somehow Case statement was causing the issue in 'Insert' write mode. I chenaged it to User-defined SQL and it worked fine. Thanks.!!

FYI, I am seeing the generated SQL in the log and it is correct. as below:
But I don't know which is the invalid character

I am trying to run user defined SQL in ODBC stage. The query is as below: Insert into schema.Table_name (Column1, Column2) (Select Clm1, Case when #Param2#=0 Then 'Clm2' Else 'Test' end as Colm2 From Table2) Note: Param2 is a job parameter But I am seeing below error ODBC function "SQLExecute&q...

Sorry.. updated the job type to 'Parellel'.

I am reading multiple csv files using Sequential File Stage with File Pattern option. But while reading Datastage is concatenating last record of first file and first record of second file. I think that is because there is no new line character after the last record of first file. How can we address...

I replaced @FM from the result and it worked perfectly. Thanks Craig!

EReplace(YourParameterField,@FM,"")

Thanks Craig. I did check the other posts related to this and they said it was the issue with the datatype of the parameter defined in the job. I have defined it as String. Since my routine is returning AUG-16 it should be accepted in the job. This is where I am getting confused and want to know if ...

I have written a server routine for executing the SQL and returning the result as below (by taking a post from this forum as ref): *Write query to a temporary sql file. cmd= "echo ":Query_File: "> G:\temp\Datastage\Query.sql" Call DSExecute("NT",cmd,Output,Retval) *exec...

I have created a datastage server routine to run SQLs by taking the below post as a reference: http://www.dsxchange.com/viewtopic.php?p=351611 My routine is: *Write query to a temporary sql file. cmd= "echo SELECT TO_CHAR(TO_DATE('201608','YYYYMM'),'MON-YY') FROM DUAL; > G:\temp\Datastage\Query...

If there was a stage called SQL in Datastage, that would have been more awesome for this requirement. However I have implemented Craig's solution of running SQL in Before/After SQL section with zero source records. It worked. thanks!