DSXchange

You may get web service call failures while loading to/unloading from salesforce.

I used UtilityGetRunJobInfo to resolve this warning.
Thank you

I am getting the below error message:
DeltaFeedFileToStagingLoadControlJob..Finish.DSLink2: nls_map_buffer_out() - NLS mapping error, row 1 (approx), row = ""Insert_ETLStatistics=1"

How to resolve this. Please help

Whenever I run the job, the start date and end date should be generated based on the current date. If I run the job on (Date: 06/01/09 ), then Load the data for 7 Months Current Month + Next 3 Months : Jun + Jul, Aug, Sept 09 Previous 3 Months : Mar, Apr, May 09 Start date : Mar -01 - 2009 End Date ...

Thanks for your help! I used the below query and it worked. select a.from_Id,a.to_Id from (SELECT from_Id as From_Id, CONNECT_BY_ROOT to_Id as TO_Id, LEVEL-1 as Pathlen FROM Id CONNECT BY PRIOR from_Id = to_Id)a, (select from_Id, max(pathlen) MAX_PATHLEN from (SELECT from_Id as From_Id, CONNECT_BY_R...

I used the following query. SELECT from_ID,to_ID,level FROM ID START WITH to_ID = 400 CONNECT BY PRIOR from_ID = to_ID; FROM_ID TO_ID LEVEL ---------- ---------- ---------- 300 400 1 200 300 2 100 200 3 But I am not sure how to get the below output? FROM_ID TO_ID ---------- ---------- 300 400 200 40...

Second file say Transfer_2.txt has following structure
FROM_ID TO_ID
100 , 400
200, 400
300 , 400

How did you get the second file?

Source is a flat file.
I have access to Oracle database

I have a requirement as stated below: From_Id To_Id 100 200 200 300 300 400 111 222 444 555 I have field named 'Id'. An Id may be transferred to another Id. Say 100 gets transferred to 200, in this case, I have to fetch all records with Id as 100 and change it to 200. This is a straight forward one ...

chulett wrote:Works fine for me. What exact version of DataStage do you have and what flavor of UNIX is it installed on?

datastage version: 7.5

Unix details:
uname -a
SunOS livdsapps16 5.9 Generic_122300-11 sun4us sparc FJSV,GPUZC-M

Please find the error message below: DSBrowser..Sequential_File_0.DSLink2: ds_seqopen() - Error in filter command "tail -1" - DSBrowser..Sequential_File_0.DSLink2: ds_seqopen() - Error in execv() - No such file or directory DSBrowser..Sequential_File_0.DSLink2: DSD.SEQOpen GCI $DS.SEQOPEN ...

I checked the Execute command activity Triggers Name: ACTCD_CA Expression Type: Custom(conditional) Expression: Convert(@FM,"",EXC_Read_Seq_AcCode.$CommandOutput) = 'CA' Name: ACTCD_SA Expression Type: Custom(conditional) Expression: Convert(@FM,"",EXC_Read_Seq_AcCode.$CommandOu...

Hi, If this is the only column available in input or if this is the only column having ~ characters coming in input , use cat |sed "s/~/'~'/g" in the filter command(Sequential file) Input: abc~cdfg~tx Output:abc'~'cdfg'~'tx If you want the output data as 'abc'~'cdfg'~'tx', then use a stage...

Since table 1 references table2 by foreign key relationship, You cannot load both tables simultaneously.
Table 2 should be completely loaded before you start loading table 1.

Use a sequencer, load table 2 in a separate job. Once it is done, load table 2 in a second job.

Hi,

hope this helps..

If Len(StageVar)=6 Then StringToDate(StageVar,"%2000yy%mm%dd") Else StringToDate(StageVar,"%yyyy%mm%dd")

Thanks,
Savis